sysdevices 1

[wg26]

Hi:

Can anyone please show me how to update sysdevices? Thanks alot..

 

[tlbroadbent]

System tables should not be updated directly. Use system procedures to update the table. If you use SQL 7 or 2000, the sysdevices table is maintained for bcakward compatibility only. In earlier versions it "contains one row for each disk backup file, tape backup file, and database file." (See SQL BOL)

What is your intent? What do you need to do with sysdevices? Which version of SQL Server do you run? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[wg26]

Thanks Terry.

I am using SQL2K. I am trying to back up a database using the following code:

Exec sp_addumpdevice 'DISK',' MySQLBackUp',
'C:\Program Files\Microsoft SQL Server\MSSQL$FABGUARDSQL\BACKUP\MySQLBackUp.bak'

there is no problem to create a device. The problem occured in the following:

Backup Database FGTestOne
To MySQLBackUp
with description = 'My What a nice backup!',
stats

SQL gave me this:"No entry in sysdevices for backup device 'MySQLBackUp'. Update sysdevices and rerun statement.".

But if I use EM to backup the database using the same device, there was not any problem. Don't really know why?

 

[tlbroadbent]

If you posted the SQL correctly, I believe the problem is the extra space in the device name in the sp_addumpdevice statement. Note the space between the quote and MySQLBackup. Remove the space and try it. You'll probably want to drop the device ' MySQLBackUp' using sp_dropdevice.

Exec sp_dropdevice ' MySQLBackUp' Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.