Richy_Boy Posted March 26, 2012 Report Share Posted March 26, 2012 Hi, I'm about to migrate one of our internal services from an SQL 2000 database to an SQL 2008 one. Easy! I thought, I'll buy a second SQL add-on for 2008 and simply restore the backup onto the new server... The restore process warning gave me an odd message, which suggested it was going to overwrite the original database on SQL 2000, so to make sure it didn't overwrite anything I changed the target database name. The message then made more sense, or at least, didn't suggest it was going to overwrite the database on SQL 2000!! When I click on restore it went off, did it's thing then threw a permission error. The user account both add-ons run under are Domain Admins, but I have also tried the SA user on the target database without any luck. Is this a bug or can you not recover a database between 2000 and 2008?? Logs: + Executing Restore database from Backup at 26/03/2012 09:59 (Execution unit 1) 26/03/2012 09:59:17: Connected to DB + Hyper-V (edgedatabase01) To volume SpiraTest_Test on DB + Hyper-V (edgedatabase01)... - 26/03/2012 09:59:17: Restoring from DatabaseServ Restore type: Full T-7: MapError: unknown Windows error 5,133 Trouble writing files, error -1015 ( unknown) 26/03/2012 09:59:38: Execution incomplete Remaining: 1 files, 68.2 MB Completed: 0 files, zero KB Performance: 0.0 MB/minute Duration: 00:00:20 (00:00:16 idle/loading/preparing) Any ideas? For now I manually exported and imported the database without any problems, but I rather *assumed* I could recover the database using Retrospect... Richard 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.