SQL Backup Error

andrewl77
andrewl77 used Ask the Experts™
on
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

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Severity 0 is warning message
Commented:
Hi,

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

SET ANSI_WARNINGS OFF
howd' you go?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial