I have a large (relative) db running in MSSQL2000 that has several .ndf files that reside on a drive that needs to be reformatted. (Raid should be 500GB, but only shows 150GB). Anyway, I am looking for the fastest way to move the data files that reside on that drive to another drive on that server that will create the least amount of down time. Options that I have explored are:
(1) Backup the database (600GB total) and then drop current DBa and recreate with new data files not on the drive in question (Backup currently takes 6hrs). (2) Backup database, then detatch Db and move the specific files to another drive and then re-attach DB using:
EXEC sp_attach_db @dbname = 'your database name',
@filename1 = 'new path\database file name_data.mdf',
. . . . . . . ,
@filename2 = 'new path\database file name_log.ldf'
Unless you can suggest another, which would an expert recommend?