Link to home
Start Free TrialLog in
Avatar of andrewl77
andrewl77

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of debuggerau
debuggerau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
howd' you go?