First restore the last full backup, then the last diff backup and finally all of the TLog backups since your last DIFF backup. remember to set your no recovery...

Mike

Sorry, missed the file copy part in the original post. I would say you have either a disk error (hotspot) or the OS is not handling the file as...

Mike

Interesting issue, have never heard of this happening. I have restored much larger databases from both tape and disk backups. Never had an OS issue at all. ...

The best way to decide a backup strategy is to determine what the company accepts as an acceptable loss. In most production OLTP systems, the answer is NONE!!!! which...

Ian

Good point, that is the one thing I have seen forgotten over and over again. Then I get the question why this login is no longer working. Not...

Valek

I love your last comment, but it comes from a SAS file, and it comes from another vendor that I can't access. I did break the tables up into...

Jeff

Luckily the data is very clean. All delimiters are in place, get this, there is only a little over 1100 rows. I actually don't have to do...

Jeff

Thanks, don't know why I didn't think of that. Guess I was too frustrated with the situation.

Lucky is correct. There is basically nothing you can do to recover the datbase now. Sorry for the bad news.

nate I'm not aware of any limits on log shipping, as long as you have the bandwith and processor power I don't see any reason why it won't work. ...

Need more information. Is this a production OLTP system or a data warehouse. Is the data loaded from another database or do you have various users/systems inserting and updating...

Lynn, nice snippet, I could have used it a month ago. Now I have to go back and edit some packages to remove a SQL Task just to set...

Just a guess, that login may have rights to another area that the database files are being sent to. Just make sure you trace the entire backup to ensure...

BTW, there is a great script to do just that in script area (shameless self plug)

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31932/

Ran into this before. It indicates that you are backing up a network share drive. If so, I recommend backing the file up locally then using a copy/move...