Incremental Backup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Incremental Backup

If i tried to take backup I am getting message saing "No entry in sysdevices for backup device ‘test3’. Update sysdevices and rerun statement"
Can you tell me how do i update sysdevices. Thanks
Krishna
This means you haven’t created a backup device named ‘test3’ and you are trying to backup to this device. Create a new backup device ‘test3’ by right clicking on ‘Backup’ under Management. Or you can avoid all this by backing up to disk directly using ‘backup to disk = ‘ option. Chaeck BOL for syntax.
Use sp_addumpdevice from query analayzer and as referred check BOL for more information. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>