Friday, March 30, 2012

How to attach a database from other server

Hi

I have created a test enviroment, by installing SQL server express and SSRS on my laptop.

I also have a production server, and i am trying to make a copy of one of its database and linked it to my test server.

How do i do it?

Thanks

Hello,

If you can take the database offline:

Take the database offline, manually copy the data and log files to your test server, then attach the database back on your production server, then on the test server.

If you can not take the database offline:

Create a backup of the database on your production server, then restore it to your test server.

Hope this helps.

Jarret

|||It works. Thanks1

No comments:

Post a Comment