That is just for the buffer cache. There is additional overhead for...

Yeah, restoring the mirror is out of the question since you can't go back without starting all over, which defeats the whole purpose of this. Doing a full schema creation...

If you create a snapshot of the databases, I'm pretty sure you could just do:

Restore Database [dbname] FROM database_snapshot = [snap_name]

edit: Snapshots are only available in Enterprise, so this wouldn't...

Yeah, I have no idea where I got that 96gb from..too much multi-posting on my part 🙂

Even if nobody is using that second instance..if it is running, there is overhead...

96gb ram and you're maxing it out?

With a 96gig box, I'd limit the buffer cache to probably 80-82gb (the sql max memory setting).

Have you tried rebooting? Or copying a \ and then pasting it into SSMS? Looks like a language issue.

There are also issues deleting data from a heap..It will not release space back as unused unless you delete WITH TABLOCK. Since he says he purges data > 120 days,...

Indeed, just tested that after I posted.

I really do not like how permissions for jobs/ssis/dts packages are handled..you either give not enough access, or sysadmin...there's almost no in-between that works.

You can create an AD group, add both users to the group, and then grant permissions to that. I'm not sure if this would work in your case, but worth...

Michael Valentine Jones (9/29/2010)

---

Derrick Smith (9/29/2010)

---

Michael Valentine Jones (9/29/2010)

---

Normally, you do not want to overwrite a prior backup, because it leaves you without a backup file if something goes wrong...

Michael Valentine Jones (9/29/2010)

---

Normally, you do not want to overwrite a prior backup, because it leaves you without a backup file if something goes wrong while you are running a...

Drop 300 tables and...

Not really...just google for some examples of auditing triggers. Chances are you set up an auditing table for this and then insert key pieces of the data that was changed...

Ninja's_RGR'us (9/29/2010)

---

Won't those stats also go out the window as the server is under memory pressure?

I'm trying it on my prod servers and I'm having doubts about the results I'm...

I do not have a SQL 2000 server anymore, but HOST_NAME() will return the hostname of the current connection. If you have an After Insert/Update/Delete and dump it to a...