• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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