October 31, 2007 at 8:39 am
We have just installed SQL 2005 on our server and are in the process of getting experience. When we created the new instance we inadvertently placed in in the wrong folder on our D drive. We then moved a database from MSDE to this SQL 2005 instal. Is there a 'foolproof' way of transferring the mssql.1 folder and its contents to the correct place, still on drive D. I have researched on the web but have been somewhat confused, we are as I said learning and would appreciate any advice
Peter
October 31, 2007 at 8:52 am
Yes.
1) Detach the database
2) Move the files
3) Attach the database
October 31, 2007 at 12:44 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply