WAY OT: SQL questionHi Sharon, You can use the WITH MOVE option to specify the new location for the files. However, a UNC path will not work. You need to move it to a physical drive on the server (or attached RAID array) using the drive letter and directory path.
Darin. ----- Original Message ----- From: Sharyn Schmidt To: [email protected] Sent: Thursday, January 31, 2008 10:25 AM Subject: [IMail Forum] WAY OT: SQL question You all are so smart on this list, I thought I'd see if I could get a quick answer to a SQL question I have. I am trying to move the location of a db using the detach - reattach function, SQL 2005, sp2. There seems to be some question as to whether this particular method of relocation will work for moving the db off the current physical drive and server it's on, and onto another server on the network. I am planning to reattach to it using the same instance of SQL, I am just trying to physically relocate the DB. Can I do it this way? I understand I will have to use the UNC path to the db when re-attaching, to tell SQL where to find it. TIA! Sharyn
