Post reply

Backup & Restoring a Database

  • August 31, 2004 at 6:40 am

    #163124

    I have a critical production database on an older Compaq server.  This database consists of tables, stored procedures, views, indexes, logins and two database maintenance plans.  A new server has been acquired to house this database.  What is the easiest way to get the database over to the new server and synchronized without interrupting the operation of the older server?

    Your comments are greatly appreciated

    SQL2DAY

  • August 31, 2004 at 8:00 am

    #521223

    Can you afford to take the databases offline for a while? If so, the BEST way is to detach the database and copy the .mdf, .ldf, and .ndf (if any) to the new location and then attach them.

    -SQLBill

  • August 31, 2004 at 9:53 am

    #521249

    I'd do a backup and restore to test. Then when you have it down, logins moved (search sp_help_revlogin), then do a full backup on source and move to produciton. Then a diff, then shutdown prod, do a log backup, move over and switch.

  • August 31, 2004 at 12:04 pm

    #521267

    Yes, backup and restore works the best.. If you want to switch server quickly then Logshipping is 2nd choice.. (BTW, I love LogShipping ^.^)

    Kun

Viewing 4 posts - 1 through 3 (of 3 total)

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