Sample Header Ad - 728x90

Best way to copy MS SQL (2000) database files to an external drive

0 votes
1 answer
384 views
We have a system running on Windows 2003, with a MS SQL server 2000 (Standard) instance as the data source. As we have sold the product, we are in the process of moving everything to the purchasing party. We have cloned the virtual machines, and when they set them up, they are stating that the databases are corrupt and would like copies of the MDF/LDF files directly. What is the cleanest way to do this? There are approximately 90 separate databases configured, and I don't really want to go in, stop/detach/copy/attach/restart, especially as I've heard that reattaching doesn't always go well. I also don't know if every database is stored in the same place. I am looking for the least involved method of confirming the storage location and copy process for 90+ database files to a connected external hard drive.
Asked by JohnP (159 rep)
Jan 31, 2020, 05:20 PM
Last activity: Feb 3, 2020, 02:00 PM