[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Error backing up SQL database

Posted on 2012-03-29
5
Medium Priority
?
906 Views
Last Modified: 2012-06-03
Hi

I have been receiving errors when backing up 2 databases on our SQL server. See example below. The workaround I have been using is to take the database offline, bring it back online, run backup again and it runs fine. Seems to happen every couple of days or so. The database log file definately exists.

SQL Server: Windows 2003 x64 R2 Service Pack 2, SQL Server 2008 Service pack 1
Backup software: Commvault 9, Service Pack 5a

Description: Error encountered during backup. Error: [The log for database 'example' is not available. Check the event log for related error messages. Resolve any errors and restart the database. A nonrecoverable I/O error occurred on file "09f8be50-067a-408c-a656-4f358805e9b3:" 995(failed to retrieve text for this error. Reason: 1815). BACKUP DATABASE is terminating abnormally. An exception occurred while executing a Transact-SQL statement or batch.]

Appreciate any suggestions.
Cheers
0
Comment
Question by:stvmph
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 4

Expert Comment

by:dee_nz
ID: 37785428
Check if there is enough free disk space for the SQL backup?
0
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 37785859
error occured when the log (LDf ) size is very big\
to check the log file size , please use
dbcc sqlper(logspace)
.
or

sp_helpdb 'dbname'

step 2)
shrink the log file,
step 3)
take the backup
1
0
 
LVL 12

Expert Comment

by:S00007359
ID: 37786348
please check the following:

1) when does the av scan the sql servers
2) when do the backups run
3) is there any sql maintenance tasks happening when the backups run
4) perform the disk defrag on the disk where the sql databases exist
5) perfrom a one off flat file backup and see what happens
6) upgrade your commserve, medi agents and sql ida agents to sp5b
0
 

Accepted Solution

by:
stvmph earned 0 total points
ID: 38025369
Under Database Properties -> Options. Auto Close was set to True. Changed this to False and that resolved the issue.
0
 

Author Closing Comment

by:stvmph
ID: 38041410
Solution found elsewhere.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

649 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