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 procedure2.copy mdf,ldf files to new server location3. attach it to new server using ssms gui or sp_attach_db proc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://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