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.

I don't know Scott, ever seen "Office Space"

It's not entirely fiction. I've seen people go through careers without really knowing much

Quotes a little flaky. I prefer to use quotes

Bob said "Steve's opinions are stupid"

I agree.

OK, I didn't want to our anyone with the editorial, and it was somewhat in humor, but seriously. Aren't there more complaints about SQL Server? I was hoping for some...

...

And you can get anything you want,

at ...

Take out the statements in the SELECT list one at a time and see when it works. Then you'll know which line it is breaking on.

Bob,

The problem is that you need to restore the log, but only up to before the delete occurred.

I would have restored the full to another database and copied the data...

Not a BI person, so I can't respond. I have pinged the author on this.

Or maybe Stefano is on the right track

That's because you're in Aaaalllllaaaassssskkkkkaaaaaaaa

where it's cooooooooooollllllllllllddddddddddddd

Makes the microwaves move slower