Monday, March 12, 2012

How to duplicate a DataBase?

Hi,
In my Win2003 Server, SQL Server 2000, we have a DataBase MyDataBase for
testing.
Now I want to make a NewDataBase which is based on MyDataBase.
Is it possilbe to duplicate a new database from MyDataBase?
Thanks for help.
JasonJason
Sure, BACKUP DATABASE MyDataBase and RESTORE MyDataBase_New WITH MOVE
option (See details in the BOL)
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:%23X%23ZsIoRGHA.2156@.tk2msftngp13.phx.gbl...
> Hi,
> In my Win2003 Server, SQL Server 2000, we have a DataBase MyDataBase for
> testing.
> Now I want to make a NewDataBase which is based on MyDataBase.
> Is it possilbe to duplicate a new database from MyDataBase?
> Thanks for help.
>
> Jason
>

No comments:

Post a Comment