Monday, March 19, 2012

Copying DBs

What is the Syntax for a statement that can copy one MS SQL DB to another Database (on a different server). Or is this even possible?See BOL (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_0ltf.asp).

-PatP|||BACKUP DATABASE
robocopy
RESTORE DATABASE

-or-

Detach database
robocopy
Attach database

-or-

Clone...lucky enough to have a SAN??

So, why don't you explain what you want to do this for. Then, we can give you a little better advice.|||What is the Syntax for a statement that can copy one MS SQL DB to another Database (on a different server). Or is this even possible?
It'd be easier for you to look into Database Wizards section.

No comments:

Post a Comment