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 |
|
JeradR
Starting Member
2 Posts |
 Posted - 2006-04-13 : 17:42:13
|
| I have a SQL 2000 server on 2003 Server with over 60 databases that need to be transferred to a different server which is also on 2003 server utilizing SQL 2000. When I attempt to run the database copy wizard it will copy all of the logins over (as well as some other information), but it won't create/transfer the database. I receive an error that reads something like "Failed to create the share 'OMMWIZE'". Both servers are using sa, with the same password. I can use DTS to transfer over tables to an existing database, but copying over a database will not work. Any ideas? |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-04-13 : 18:54:08
|
Use Backup and Restore:1. Make a backup of the Database on the old server.2. Restore the database onto the new server with the MOVE option.It is usually the best way to do it, because it makes an exact copy of the database with all users, objects, permissions, etc.More than likely, you already have existing backup jobs  , so all you have to do is setup scripts for the restores.CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-14 : 04:37:17
|
| +1 for Backup & Restore.You will then need to synchronise the Server Logins and Database Users - there are simple scripts to do that, just ask when you need help with that.Kristen |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-04-14 : 07:19:19
|
quote:
Originally posted by Kristen
+1 for Backup & Restore.You will then need to synchronise the Server Logins and Database Users - there are simple scripts to do that, just ask when you need help with that.Kristen
How to transfer logins and passwords between instances of SQL Server:http://support.microsoft.com/kb/246133/CODO ERGO SUM |
|
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-04-14 : 10:40:48
|
| Michael, little off the topic but can sp_help_revlogin can be used for transfering login information from SQL2K to SQL2005.Also, for my knowledge has anyone encounter any problems while using Transfer login task in DTS or (SSIS)? |
|
|
|
|
|
|
|
|
SQL Database Copy Wizard