Wednesday, March 7, 2012

Copy and move the database to another server

I have a SQL Server database(NWind) available in a stand alone server. I have
a CD writer in this stand alone server. I need to create an instance of this
NWind database into another server.
How can I copy the database from my first server into my second server.
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
|||If I use Detach database does the database in the first server be still
available once I move it to another server.
"Shadow" wrote:

> HOW TO: Move Databases Between Computers That Are Running SQL Server
> http://support.microsoft.com/?id=314546
>

No comments:

Post a Comment