Solved

SQL Backup Error

Posted on 2009-05-14
6
1,284 Views
Last Modified: 2012-05-07
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
Comment
Question by:andrewl77
  • 2
6 Comments
 
LVL 23

Accepted Solution

by:
debuggerau earned 43 total points
ID: 24391124
0
 
LVL 18

Assisted Solution

by:jmoss111
jmoss111 earned 41 total points
ID: 24392140
Severity 0 is warning message
0
 
LVL 3

Assisted Solution

by:csenasa
csenasa earned 41 total points
ID: 24392537
Hi,

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

SET ANSI_WARNINGS OFF
0
 
LVL 23

Expert Comment

by:debuggerau
ID: 24760484
howd' you go?
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Group by correlation 4 55
Need help with a query 3 46
SQL HELP 2 82
SQL 2005 - Memory Table Column Names 11 69
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now