copy database to CD

  • If you can take the database offline, you can do this: Detach it from SQL Server using sp_detach_db, copy it over, and then reattach it using sp_attach_db (you'll probably want to run this immediately on the originating SQL Server as soon as the copy is done). You'll need to handle any login/user SID mismatches, but that's what sp_change_users_login is for.

    If you need the database to remain online, taking a backup and putting that on CD works, but you'll need to restore the backup on the second SQL Server.

    K. Brian Kelley
    @kbriankelley

Viewing post 1 (of 2 total)

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