chang.hahn (8/24/2012)

---

If your backup script is using the native "Backup Database" then it's not... Litespeed backup scripts are different something like "Litespeed.exe -d..." something like that... it's been 6 months...

Barry - the server is not on a domain, therefore you cannot add a domain user to SQL Server and authenticate.

For Windows Authentication to work in a WORKGROUP - you...

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...