April 18, 2008 at 9:15 am
I am trying to backup a database from data protector but I get this error message only on 1 instance
[Normal] From: OB2BAR_Main@ecproddb01.domain.corp.com "(DEFAULT)" Time: 4/17/2008 7:05:16 PM
SQL statement:
BACKUP DATABASE (Indicadores) TO
VIRTUAL_DEVICE = "Data Protector_(DEFAULT)_Indicadores_18_58_37"
WITH NAME = 'Data Protector: 2008/04/17 0217', BLOCKSIZE = 4096, MAXTRANSFERSIZE = 65536;
[Critical] From: OB2BAR_Indicadores_0@ecproddb01.domain.corp.com "(DEFAULT)" Time: 4/17/2008 7:05:17 PM
Virtual Device Interface reported error:
The object was not open.
See also Data Protector debug.log and SQL Server error log for details.
[Normal] From: OB2BAR_Indicadores_0@ecproddb01.domain.corp.com "(DEFAULT)" Time: 4/17/2008 7:05:18 PM
Completed OB2BAR Backup: ecproddb01.domain.corp.com:/(DEFAULT)/Indicadores/0 "MSSQL"
[Major] From: OB2BAR_Indicadores_0@ecproddb01.domain.corp.com "(DEFAULT)" Time: 4/17/2008 7:05:18 PM
Aborting connection to BSM. Abort code -2.
[Warning] From: OB2BAR_Main@ecproddb01.domain.corp.com "(DEFAULT)" Time: 4/17/2008 7:05:19 PM
Error has occurred while executing a SQL statement.
Error message: ' [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'Indicadores' is full. Back up the transaction log for the database to free up some log space.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not write a CHECKPOINT record in database ID 13 because the log is out of space.'
The log file is in un restricted mode and everytime I checked it has 97Mb of free space. Can somebody help?
May 5, 2008 at 3:10 pm
It is a space issue.
My understanding is that Data Protector is an HP tool for backup/recovery.
Find the path of logs for this tool and check its space.
Best luck.
December 28, 2008 at 8:59 pm
I am also getting Aborting connection to BSM. Abort code -2 when running backup for the MS SQL 2000 database. Have check and ensure enough diskspace in the drives where the logs resides but the problem persist.
December 28, 2008 at 10:30 pm
The error is telling you everything you need to know.
Error message: ' [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'Indicadores' is full. Back up the transaction log for the database to free up some log space.
This is telling you that the recovery model for the database is full recovery. Full recovery model requires transaction log backups be run on a regular basis. Depending upon your system requirements, that could be as often as every 5 minutes - up to every couple of hours. This really depends upon how much data your organization can afford to lose in a disaster.
The first thing you need to do is backup the transaction log. Backup the transaction log to a drive that does not contain your database files or log files.
Once that is done - your normal backups should run successfully.
The next thing you need to do is schedule and run regular transaction log backups. Once that has been done, you will be able to determine (from the size of the transaction log backups) how large the transaction log should be. You can then perform a one time shrink to a size that is a little bit larger than the largest transaction log backup.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2008 at 1:09 am
And read through this - http://www.sqlservercentral.com/articles/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2008 at 9:54 am
Gail - I have to make sure I remember this link. I see this issue so often now that it would just be easier to link to the article than explain it every time. 😀
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 29, 2008 at 10:37 am
Jeffrey Williams (12/29/2008)
Gail - I have to make sure I remember this link. I see this issue so often now that it would just be easier to link to the article than explain it every time. 😀
That's the main reason why I wrote the article in the first place. 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 29, 2008 at 10:43 am
I know - I have now updated my signature and added two links, one of which is that article.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply