SQL Server Performance

Incremental Backup

Discussion in 'SQL Server DTS-Related Questions' started by issolla, Oct 3, 2003.

  1. issolla New Member

    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
  2. ykchakri New Member

    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.
  3. satya Moderator

    Use sp_addumpdevice from query analayzer and as referred check BOL for more information.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page