 |
 |
According to this article from MSDN. Yes you can use that method. http://msdn.microsoft.com/en-us/library/ms189625.aspx From: Ehren Benson [mailto:[log in to unmask]] Sent: Wednesday, April 13, 2011 10:27 AM To: [log in to unmask] Subject: [MSUNAG] mssql detatch Hi, I want to detach a MSSQL 2000 database and then attach it to a 2008R2 server on a DIFFERENT box. (I've read that it will automatically upgrade the database when you do this). If I detatch it from the source box, copy the files to the new box and attach the copy is it possible to then re-attach the original to the original server as well? Basically I want to move this database to a new server but have it online to test for a few days before it goes live, but I want the original to still be available in the meantime. I'm not a big database guy so I'm tryin to figure this out ;) Thanks! Ehren J. Benson, MCSE Windows Systems Administrator Department of Physics and Astronomy Michigan State University 1209 A Biomed Phys Sci [log in to unmask]<mailto:[log in to unmask]> 517-884-5469