Jump to content

Restore / Migration of SQL 2000 > 2008?


Richy_Boy

Recommended Posts

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

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...