October 1, 2008 at 2:55 pm
I used the copy database wizard trying to move a database from SQL Server 2000 to SQL Server 2005. I chose not to detach and attach the database because the database is a production database.
However I got an error during when it tried to execute the job. Is it because the servers are in different domain? Do I need to create a link server?
October 1, 2008 at 3:25 pm
What is the error you're getting?
I actually reported a bug on this feature which, last time I checked, had not yet been resolved. The problem is (was?) that it wouldn't let you change file locations.
October 1, 2008 at 3:42 pm
Loner (10/1/2008)
I chose not to detach and attach the database because the database is a production database.
use backup and restore then!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2008 at 6:41 am
This was the error I got.
2008-10-01 16:48:36.38 spid57 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2008-10-01 16:48:37.19 spid57 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2008-10-01 16:48:37.19 spid57 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
October 2, 2008 at 6:43 am
If I use backup and restore, do I need to do anything special?
October 2, 2008 at 10:52 am
A cachestore flush should not be preventing the move.
Have a look at this for some more info:
I did a really quick msdn search for you and found this:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2673397&SiteID=1
If you choose to go the backup / restore route, you will want to specify the COPY_ONLY option. Otherwise you'll interfere with your normal backup chain.
October 2, 2008 at 11:25 am
Thanks Pam. I have to sign on as SA in both servers in order to do the copy database wizard.
October 2, 2008 at 11:28 am
I was getting excited too early. It still did not work but did not give me an error. No clue.
October 2, 2008 at 5:34 pm
you could still use backup\restore
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2009 at 7:05 am
Hello all,
I'm trying to copy a database from a sql2000 to a sql2008 environment, using the copy database wizard (on destination env.).
It fails.
The errormessage (on the sql2008 env.) contains: "80 database compatibility level is not supported".
I don't understand. It is claimed that the wizard could be used to copy from sql2000 (which is comp.level 80) to sql2008.
Anyone any idea?
thnx.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply