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 |
|
nikosdra
Starting Member
1 Post |
 Posted - 2003-09-06 : 06:15:04
|
| Hello allI have a SQL Server 2000 database in a remote host and I want to mave all my data to another remote (virtual) host, where on both machines I do not have direct access. Can you advise me what is the best way to make this transition?Thank You in advanceNick |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-09-06 : 09:04:34
|
Nick, you will need at least *some* kind of access to the server to be able to move the database. Do you want to stop people from using the first server after the data has been transferred, and start using the second server? Take a backup of the database on the first server, copy it over to the second server and restore it. It should be fairly straight forward, but there are a few things you will need to cater for, particularly transferring SQL Server Logins and mapping them to Database Users. If you have a high-traffic site, you might want to take a transaction log backup on the first server, after the database has been restored on the second, and restore it on the second server, to ensure any transactions that took place during the transfer are also copied.Owais
Make it idiot proof and someone will make a better idiot |
 |
|
|
|
|
|
Transfering data from one machine to another.....