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

SQL Backup Error

Hi Experts,

I have setup sql server express on a windows server 2003.  I have also setup SQL Scheduler to manage the backups of the databases automatically each night.  Below is a script that is executed to backup the database.  I get the following error in the user log:

Job Execution Log:

10 percent processed. (Severity 0, state 1, error number 3211, line 7)
20 percent processed. (Severity 0, state 1, error number 3211, line 7)
30 percent processed. (Severity 0, state 1, error number 3211, line 7)
40 percent processed. (Severity 0, state 1, error number 3211, line 7)
50 percent processed. (Severity 0, state 1, error number 3211, line 7)
60 percent processed. (Severity 0, state 1, error number 3211, line 7)
70 percent processed. (Severity 0, state 1, error number 3211, line 7)
80 percent processed. (Severity 0, state 1, error number 3211, line 7)
90 percent processed. (Severity 0, state 1, error number 3211, line 7)
Processed 3672 pages for database 'dbw_bentjobs', file 'dbw_bentjobs' on file 1. (Severity 0, state 1, error number 4035, line 7)
100 percent processed. (Severity 0, state 1, error number 3211, line 7)
Processed 1 pages for database 'dbw_bentjobs', file 'dbw_bentjobs_log' on file 1. (Severity 0, state 1, error number 4035, line 7)
BACKUP DATABASE successfully processed 3673 pages in 11.150 seconds (2.698 MB/sec). (Severity 0, state 1, error number 3014, line 7)

What could be the cause of these errors?

DECLARE @BackupName VARCHAR(255) 
DECLARE @BackupFileName VARCHAR(255) 
 
SET @BackupName = 'dbw_bentjobs_' + convert(nvarchar(20), getdate(), 112) + N'.bak' 
SET @BackupFileName = N'C:\sqlbackup\' + @BackupName 
 
BACKUP DATABASE [dbw_bentjobs] TO  
DISK = @BackupFileName WITH NOFORMAT, NOINIT,  
NAME = @BackupName, SKIP, REWIND, NOUNLOAD,  STATS = 10

Open in new window

0
andrewl77
Asked:
andrewl77
  • 2
3 Solutions
 
debuggerauCommented:
0
 
jmoss111Commented:
Severity 0 is warning message
0
 
csenasaCommented:
Hi,

hi try to set the warning messages off and excute your statements.

SET ANSI_WARNINGS OFF
0
 
debuggerauCommented:
howd' you go?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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