Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL_MAZFS
Starting Member
9 Posts |
 Posted - 2013-06-21 : 02:55:42
|
can anybody tell me how to attach database file from other location in sql server 2005??????????
mazfs |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-21 : 03:06:50
|
1.detach the databse first using sql management studio gui or sp_detach_db procedure
2.copy mdf,ldf files to new server location
3. attach it to new server using ssms gui or sp_attach_db proc
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
|
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-07-25 : 00:29:19
|
You can not detach a SQL server database if any of below points are true:
1. Database is being mirrored in the mirroring.
2. Database is suspect.
3. Database is a system database.
4. Database is replicated & published. |
|
|
|
|
|
|
Attaching and deattaching database