Johan,

Whether you are correct or not, it would be nice to acknowledge those lost.

I was hoping we're have more discussion on data centers and unexpected issues rather than anything...

While I'm sure there are cases where this applies, it could easily be abused as well. The US is a little sue-happy at times and I'm not sure this should...

It's good to see people that believe this is as horrible as I think. There's definitely blame to go around as passwords should have been changed ASAP when someone in...

I was hoping for some good SQL Server comments, but maybe we just like picking on Oracle

How about these:

I love that SQL Server...

If this is just a modification, you might want to submit it as a script.

http://www.sqlservercentral.com/Scripts/AddScript.asp

Bob is correct. The word from MS engineers is don't shrink the DB. Shrink the log if needed, but not the db. Can mess up indexing efficiency (in terms of...

sysadmins alias to dbo.

Remove the builtin_admins from the sysadmin group.

You get the value from the "INSERTED" trigger. Meaning something like this:

create trigger ...

for update

as

update audit_table

set val = i.val

from inserted i

where i.table_id = audit_table.table_id

There have been great suggestions in this thread, but I'd submit that your hardware is likely very underpowered for this setup. If you really have that many connections, you need...

Are you restoring a new db on both servers? Or an existing one on the old server? Also, are these from local disk for the backup file?

Does seem a little...

I'd agree with Jeff on that one. It gives you real world situations and problems that you have to solve.

Getting a book and working through it will help as well....

I don't have a complete list, but here's some reading on the topic.

http://www.sqlservercentral.com/columnists/sjones/worstpracticedetaileddisasterplans.asp

http://www.sqlservercentral.com/columnists/sjones/2744.asp

http://www.sqlservercentral.com/columnists/sjones/incidentresponserespondingtoanincident.asp

You'll never keep up with specific plans. The important things are to practice restores, so you have confidence...

I don't think you can do this. The database needs to finish recovering.

Do you know if it's in roll forward or roll back? Check the error log.

Stephanie,

While I agree that someone should have noticed backups failing, I can see the problem there. How does a network admin check the backups?

he looks for failures. You'd need some...

That's a great song. Remember hearing it for the first time, 1987, driving to UVa after summer vacation.