• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

TSQL Full Backup Error Help...

Hi everyone.

I am currently taking a class on SQL Server 2000.  Part of my assignment is to do a full backup of the Northwind databse use TSQL.  I've typed the code below, but am receiving an error when I try to run it.  Can anyone help me with this or guide me in the right direction?  I am clueless as to why this code will not run.

Thanks,
Rhonda


--Full backup of the Northwind database.  
--Name backup "RhondaColeman_WindBackup_TSQL"

USE MASTER
BACKUP DATABASE Northwind TO NWbackup
WITH
NOUNLOAD,
NAME = 'RhondaColeman_WindBackup_TSQL',
DESCRIPTION = 'Full backup of Northwind Database using TSQL'


****Error I am recieving*****

Server: Msg 3206, Level 16, State 1, Line 5
No entry in sysdevices for backup device 'NWbackup'. Update sysdevices and rerun statement.
Server: Msg 3013, Level 16, State 1, Line 5
BACKUP DATABASE is terminating abnormally.
0
Rhonda1928
Asked:
Rhonda1928
1 Solution
 
SireesCommented:
This means you haven't created a backup device named 'NWbackup' and you are trying to backup to this device.

Create a new backup device 'NWbackup'  by right clicking on 'Backup' under Management. Or you can avoid all this by backing up to disk directly using 'backup to disk = ' option. Check BOL for syntax.
0
 
Rhonda1928Author Commented:
Thank you Sirees !!!    That was it.  I had not created the backup device.  Just created it and ran the backup without a problem.

Thanks again !
Rhonda
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now