Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY

asked on 

BACK UP FAILED ERROR.

I am finding below error in the Event3041 in the event viewer stating MSSQLSERVER.SQLServer2K8.LogBKUPFailed.Alert;  Desc: BACKUP failed to complete the command BACKUP LOG vivek but database is existing in the running fine. All jobs also executing properly. these are data i found in logs

C:\Windows\system32>(
md "E:\MSSQL\BAK\vivek"  
 sqlcmd -Q"declare @backup_file_name varchar(1000) set @backup_file_name = 'E:\MSSQL\BAK\vivek\vivek_'+convert(varchar(24),getdate(),112)+'_'+Replace(substring(Convert(varchar(24),getdate(),114),1,5),':','')+'_FULL.bak' declare @cmd varchar(4000) set @cmd = 'BACKUP DATABASE [vivek] TO DISK = '''+@backup_file_name+''' WITH INIT' if @@version not like '%SQL Server 2005%' set @cmd = @cmd + ', COMPRESSION' exec(@cmd) " 
 for /F "skip=3 tokens=*" %j in ('dir "E:\MSSQL\BAK\vivek"\*.bak /o-d /b') do (del "E:\MSSQL\BAK\vivek\%j" )
)
A subdirectory or file E:\MSSQL\BAK\vivek already exists.
Processed 203896 pages for database 'vivek', file 'vivek' on file 1.
Processed 5 pages for database 'vivek', file 'vivek_log' on file 1.
BACKUP DATABASE successfully processed 203901 pages in 10.412 seconds (152.994 MB/sec).

C:\Windows\system32>(del "E:\MSSQL\BAK\vivek\vivek_20110712_2200_FULL.bak" )
Microsoft SQL Server 2008Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
marappan
Avatar of RafaelVetrone
RafaelVetrone

Where is the error? For me everything went fine.
The command md "E:\MSSQL\BAK\vivek"  generated this message that the directory already exists. And then the backup command occurred normally as evidenced by the message
Processed 203896 pages for database 'vivek', file 'vivek' on file 1.
Processed 5 pages for database 'vivek', file 'vivek_log' on file 1.
BACKUP DATABASE successfully processed 203901 pages in 10.412 seconds (152.994 MB/sec).
So I don'r see any errors.
Avatar of VIVEKANANDHAN_PERIASAMY

ASKER

We see the error in the eventviewer on server where sql is hosted. Event3041.
My worries is if backups are taken successfully, then we are getting the error logged in the event viewer.
ASKER CERTIFIED SOLUTION
Avatar of Ramesh Babu Vavilla
Ramesh Babu Vavilla
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
I found out this below error.
 The transaction log for database 'vivek' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases.

But when I checked the data drive, there are 30.7 GB free space.What should i do to avoid this problem completely.
SOLUTION
Avatar of marappan
marappan
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo