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
