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 |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2001-02-01 : 11:24:59
|
| Hi All I need to copy the database from one server to another server. I know we can detach and then attach the database or by Backup/Restore or DTS. But the source data base server having one sortorder and I want the destination different. I want to do in the following way, please correct me if I am wrong1) Take complete backup2) Copy the data files and log files to some other server3) Install the destination server with the same sort order as source server4) Now restore the database 5) Change the sort order to required one by SP_configre option6) Take care about the logins and their passwordsShastry.V |
|
|
|
|
|
Moving Database