I have a small SQL Server installation on NT 4.0 Workstation (SP3). I took all the default options when installing and ended up with device files in c:\mssql\data. (Master.dat, Msdb.dat, Msdblog.dat) Later, another administrator has added two more device files in the same location. As the C drive is getting close to full - I wish to move these device files to another disk. What is the recommended procedure?

-- Anonymous, June 01, 1999

Answers

David,

You can use the stored procedure sp_movedevice. This is documented in SQL Server Books Online in an article titled, "Moving a Device".

Good luck,

Eric

-- Anonymous, June 04, 1999