November 17, 2015 at 5:20 pm
I took a backup of a database on a 2005 version of sql server and copied the backup to a different server running SQL 2008R2. The normal restore process is not working. I tried creating a backup device for the 2005 backup and that did not work either. Is there an easy way to do this without using attach and detach?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 18, 2015 at 12:17 am
Define 'not working'.
A backup from 2005 can be restored to 2008 R2 without any problems, so there's possibly something wrong with your backup file, or syntax.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 18, 2015 at 1:24 am
You may also want to make sure you "editions" match.
Example, I wouldn't expect an Enterprise Edition -> Standard Edition backup and restore to work if the EE edition database was using some entrprise only features.
Cheers
S
November 18, 2015 at 10:04 am
I needed a domain account for the SQL server service. The editions did not matter.
Success!
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply