Move DB off C Drive
Posted on 2003-03-05
I am fairly new to SQL Server and am using SQL Server 2000. I have SQL Server installed on my PC, but it's not installed on the network. One of my databases has grown very large and I need to move it off my C drive.
This is what I've tried using the Northwind db for practice...
I tried going through EM and received the message that the network device I wanted to restore my db to was not supported for database files. So, I tried this approach: I created a new device using the sp_adddumpdevice proc
code: sp_addumpdevice 'disk' 'Northwind_device' 'h:\nakamura\Northwind.dat'
Then I backed up the database to the new device.
Next, I dropped the database
Then I tried to restore to the h: drive using this code:
RESTORE DATABASE Northwind
WITH MOVE 'Northwind' TO 'h:\nakamura\Northwind.mdf',
MOVE 'Northwind_log' TO 'h:\nakamura\Northwind.ldf'
I get the same error - that the network device is not created for database files.
Any help would be sincerely appreciated. I'm the only one in the office who is using this software and I'm wingin' it.