June 8, 2006 at 7:29 am
I have 200 DB in one server, I want to migrate all this in new server, what is the easy way to do this??
Also, how can I retrieve all the 200 DB in my server and there physical location (data and log files).
I want to do this above in Log shipping, I have never done this before can anyone tell me the right direction to do.
Thanks
Nita
June 8, 2006 at 2:26 pm
Do you want to copy the databases to another server and then keep the data in sync with the original databases? Or is this a one time move, like to a replacement server?
If it's the latter, there are several choices. This article explains them:
http://support.microsoft.com/kb/314546/en-us
If it's the former, log shipping would be the logical choice. In SQL Server 2000, built-in log shipping is only available in Enterprise Edition. If you have Standard Edition, here's a good article about setting up your own:
http://www.sql-server-performance.com/sql_server_log_shipping.asp
sp_MSforeachdb 'use ? Print DB_Name() Select * from sysfiles' will show the location of database files.
Greg
Greg
June 12, 2006 at 1:44 pm
If the two server have the same paths a backup and restore may work
Mike
June 12, 2006 at 1:48 pm
How about backing up using maintenance plan and restoring manually?
June 12, 2006 at 2:37 pm
We have a similar enviroment here. What we did was this:
- Backup all the db's pointing the path to new server drive.
- If the directories are different from the old server use WITH MOVE option to restore backups.
- BCP out the logins from old server and BCP in the logins into the new server.
Above just the flow chart kind of thing. There are lot more things to be done to complete the process.
June 13, 2006 at 6:39 am
I've got an old article that also has notes on how to do it:
http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply