200 DB

  • 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

     

     

     

  • 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

  • If the two server have the same paths a backup and restore may work

     

     

    Mike

  • How about backing up using maintenance plan and restoring manually?

  • 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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply