Backup and incremental backup - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Backup and incremental backup

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-07 : 07:51:47

Krish writes "I i tried to execute the statement mentioned below:
BACKUP DATABASE test2
TO test3
WITH init
GO

This is not executing. It is giving the error message "No entry in sysdevices for backup device 'test3'. Update sysdevices and rerun statement"

What I have to do? Also how do in schedule this backup?

Thanks
Krish"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-07 : 12:25:46

Well, you didn't add a backup device called test3. Instead of using backup devices, just use a path and file name:

BACKUP DATABASE test2
TO DISK = 'E:\MSSQL\BACKUP\test2.bak'
WITH INIT

To schedule this, just set it up in the SQL Server Agent.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources