Resolved. login123 password expired. From now on, it’s set not to expire.

Thanks to all.

We had a 50 min power outage. We did not get any outage notification from hosting company in time. Our websites are down, no rdp to servers during...

Thanks for the reply..everything is good now

We...

Raghavender (1/17/2010)

---

Hi Team,

We have created a maintenance plan for T-Log backups. From the last 2 days, its getting failed. We have checked the selected databases option. 3 days back we...

Hi GilaMonster, I was just going through this thread, just want to know

what is the value of log_reuse_wait_descr to shrink...

If shrinking datbase/logfile causes index fragmentation and poor performance. Then why that option is there in SQL Sever.

If you don't shrink logfile, lets say logfile grows rapidly and there...

Thanks to all, i was selecting wrong back up file

So Now i want to verity the updated data

I have one full backup file 12/31/2009 12:20AM

Diff backup file 12/31/2009 06:35 AM

TLOG...

You mentioned this is a production server. Do you have...

Thanks for your reply GilaMonster!

Presently I am saving database changes script/code, input/outpur and also approved email in a network share for future audit.

In SQL is there any way to perform...

Bru Medishetty (12/29/2009)

---

If you are going to overwrite the mdf and ldf files at the secondary server (new server) the reportserverDB existing on that server will be overwritten and will...

Steve Jones - Editor (12/29/2009)

---

Note that moving those databases to the secondary server, either with detach/attach or just a copy over of the mdf/ldf (note that you need to stop...

No reports are deployed in secondary server.

Your ansewer is confusing to me. Can you please explanin in details.

We are moving our production to a another server, we will use this...

Some reports are there.

Restoring Reporting databases are not like normal backup and restore?

I am planning to below steps

1. Stop report server

2.detach database in primary server

3.copy mdf and ldf file to...

Currently we are not using Reporting server. Earlier we used to get a report for internal application(not for any client application).

What you advice

Bru Medishetty (12/29/2009)

---

Yes you can.

The only restriction I know and and am aware of is that a backup from a higher Version cannot be restored on an earlier version. Like...