Solved

SQL Backup Error

Posted on 2009-05-14
6
1,290 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Data via Excel--performance issues 2 56
Incremental load example 2 55
Two tables - Sum of values - What is the difference 31 54
Addition to SQL for dynamic fields 6 47
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

791 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