Are you sure the backups are actually setup to use compression? Just setting the default will not override the value in a maintenance plan if that value was specifically...

GSquared (8/20/2012)

---

Actually, if you're breaking the log chain anyway, you could just set to Simple Recovery for the duration of the delete process, and run a checkpoint after each batch....

Do you care about being able to restore the system to a point in time after this delete process? If not, then I don't see a problem - however,...

GilaMonster (8/20/2012)

---

Yup, the DB will be recreated exactly as it was at the time of backup. Caught me too, had a 50GB backup file that needed 120GB to restore (empty...

Gazareth (8/20/2012)

---

To a point, yes. But I'd be impressed if you were hitting the dev server...

Indianrock (8/20/2012)

---

Would DFS replication actually work where the data resides on our primary Netapp filer and would be replicated to a DR ( mirror ) Netapp filer? Yes we...

Michael Valentine Jones (8/10/2012)

---

I agree on the having a different account of each SQL Server with a long random password, but I think you need to store the password. ...

Indianrock (8/15/2012)

---

My impression was that backups done via Netapp's snap manager for sql could be done very often, very fast and that for databases in full recovery, its an either...

I would cheat...and download SQL Search from Redgate and let that utility do the searching for me. :w00t:

Instead of using Netapp and Snap - you want to implement replication across to the DR site for your image files. This way, all image files are immediately written...

Run DBCC LOGINFO for that database. This will show you the number of VLF's defined in the log file for that database.

If you initially created the log file at...

The installation grants all of the rights necessary for that service account to run SQL Server.

That does not mean that service account has full administrator access to the server, or...

Are you running - or going to run either SSIS, SSRS or SSAS on this same box? If not, then 8GB is probably excessive - if you will be...

CTE's are not replacements for temp tables or table variables. A CTE will be incorporated into the actual query...

As a one-time process where there is identified fragmentation issues on the drive - I would take the services offline, perform the defrag and bring everything back up.

As a scheduled...