Jump to content
Sign in to follow this  
Richy_Boy

Restore / Migration of SQL 2000 > 2008?

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×