Moving devices for SQL Server 6.5greenspun.com : 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".
-- Anonymous, June 04, 1999