Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
btamulis
Yak Posting Veteran
64 Posts |
 Posted - 2010-10-09 : 12:41:14
|
| I am trying to use the Copy Wizard on my SQL2000 server to copy my databases to a new install of SQL2008 server.I've used the wizard before without problem. This time, after selecting the destination server - (which I see no problem) I get my message 'can't find destination server'.Is there any settings in configuration manager on the SQL2008 server that i need to worry about? The SQL2008 server is operational all services are running.... Thanks in advance - I searched this forum but did not find anything.... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-09 : 13:06:22
|
| just restore your sql 2000 backups to sql 2008 |
 |
|
|
btamulis
Yak Posting Veteran
64 Posts |
Posted - 2010-10-09 : 13:15:36
|
| Okay - you're going to have to be more specific.If I backup (all the databases I want to copy) on the SQL2000 server as a device (bak) file.Then go to the SQL2008 server (which has no databases except the system databases) click 'restore' - will SQL2008 create the database?Or do I have to create the database (first) in SQL2008 and then restore from the device?I have 10 databases to copy......I was hoping the wizard would work...Thanks for your patience.....I've used the wizard before - but it was same physical machine (different instances)...I've never copied across 2 servers before.........Do you know if the SQL2000 to SQL2008 is not viable due to SQL different versions?Thanks again....... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-09 : 13:23:19
|
| your sql 2000 backups will restore to sql 2008 just fine. do you mean to say that you aren't already taking backups on a regular basis? this is the very first thing you need to take care of. no matter how you choose to move the data, you need to have backups.i tell new DBAs that the most important thing a dba can know is backup/restore. everything else is secondary.in your case, make 10 seperate backups (10 backup files) then restore them to sql 2k8.if any of the databases are not in simple recovery model, you'll need to take transaction log backups too.copy database wizard is not the best way to do this in my opinion. |
|
|
|
btamulis
Yak Posting Veteran
64 Posts |
Posted - 2010-10-09 : 16:24:15
|
| Thanks Russell.I backed everything up. I created new databases on the SQL2008 server. Restored these from the SQL2000 backups.Now I'm running my install login scripts which will create the users in master db and reset db owner, map to db's etc...I think I'll be okay...... |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-09 : 21:11:08
|
| great! glad to hear it |
|
|
|
|
|
|
Copy SQL2000 to SQL2008R2 Server