Eric :

I have a SQL Server 6.5 on which the user db's and the system db's are on two different physical drives. I want to move the user db's to the same physical location where i have my system databases. I am trying to use the sp_move device procedure but it fails....why?

sp_move device device_name, new_path

Prem

-- Anonymous, July 11, 2001

Answers

Prem,

To assist in finding a good answer to your question, please come back to the SQL Server Database Administration forum and post the exact error message(s) and error number(s) that you are receiving.

Thank you,

Eric

-- Anonymous, July 11, 2001

Eric :

The name of the backup device which is on the c drive is PREM_TEST.DAT

I want to move this device to E:\MSSQL\DATA\PREM_TEST.DAT

when i run this tsql command it fails

sp_move device PREM_TEST.DAT,E:\MSSQL\DATA\PREM_TEST.DAT

i also tried it with single quote but it fails

sp_move device 'PREM_TEST.DAT','E:\MSSQL\DATA\PREM_TEST.DAT'

Error message is

Msg 170, Level 15, State 1 Line 1: Incorrect syntax near 'PREM_TEST'

Thanks Prem

-- Anonymous, July 11, 2001

Prem,

Follow the instructions in the article, "INF: How to Move a Device to Another Location" at: http://support.microsoft.com/support/kb/articles/Q181/6/02.ASP

In particular, don't forget to install the stored procedure sp_movedevice from the SQL Server Books Online.

Good Luck,

Eric

-- Anonymous, July 12, 2001

Eric :

When i try to install the sp_movedevice stored procedure from the Books Online, i get the following message

Configuration option changed. Run the reconfigure command to install

Please advice

Thanks Prem

-- Anonymous, July 13, 2001

Prem,

Execution of the sp_configure command produces that message. This is normal.

However, looking at the code for the sp_movedevice store procedure, I would think that you would see that message when you executed sp_movedevice rather than when you create the stored procedure. Double check that the sp_movedevice stored procedure has actually been created.

Eric

-- Anonymous, July 13, 2001