stvmph
asked on
Error backing up SQL database
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-4 f358805e9b 3:" 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
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-4
Appreciate any suggestions.
Cheers
Check if there is enough free disk space for the SQL backup?
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
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solution found elsewhere.