Moving devices for SQL Server 6.5 : LUSENET : SQL Server Database Administration : One Thread

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



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,


-- Anonymous, June 04, 1999

Moderation questions? read the FAQ