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 |
|
reydp
Starting Member
5 Posts |
 Posted - 2004-08-10 : 04:57:12
|
| hello,I am new to SQL SERVER Administration. Can you guys assist me on how to copy db from one server to another? Is there such a thing like IMP/EXP in SQL SERVER like ORACLE have?thanks in advance. |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2004-08-10 : 10:46:56
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463 |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-08-10 : 11:10:38
|
| Simplest process is to backup, copy backup file to new server, and restore.Important things to note: users are part of the database, but LOGINs are part of the Server, so you will need to check for your logins on the new server, and ensure that the ones you need exist, and then "auto_fix" your users (see BOL sp_change_users_login).Alternatively, after restoring, drop the disconnected users from the database, and use the scripts you (hopefully) have to create the required logins and users.HTH*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
reydp
Starting Member
5 Posts |
Posted - 2004-08-10 : 22:58:55
|
Thanks for your replies guys,I will take a look into your advise and hopefully I can copy db to other server without a problem. |
|
|
|
|
|
|
copy db from one server to another