June 12, 2006 at 1:48 am
What is the easiest way to copy a sql server DB (2005 in this case) to a CD so it can be recreated (in full) on another computer that is running sql server that does not have this DB on it.
Any help will be appreciated.
Brin
June 12, 2006 at 5:37 am
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 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply