This is a fairly static database, only updated once a month, at which time we get a compressed (RAR) file from the organization. That organization has a process where they...

Thanks all for the great help! I'm breathing easier now....

Boy, that was an ordeal. We finally got it to work by detaching it from the source server, ftping it, then renaming it and attaching it on the target server....

This is a restore we've done through SSMS gui every month for years. We have verified that the source is SQL 2005 SP3 and target is SQL 2008 SP1. The...

Thanks for the input, Steve. We have books and most of the DBAs are certified on 2005, but want a CBT to get us relatively quick training on the changes...

When I became a DBA overnight because the main DBA was fired, the book I read that was really helpful was SQL Server 2000 for Experienced DBAs by Brian Knight....

This is great! Thanks so much.