Showing posts with label writer. Show all posts
Showing posts with label writer. Show all posts

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
>

Copy and move the database to another server

I have a SQL Server database(NWind) available in a stand alone server. I hav
e
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
>

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
>