Backup Exec and MS SQL Server 2005
Hi!
I'm trying to do a log backup of a SQL Server 2005 database with Backup Exec
v11d (incl. SQL agent).
But I get the following error:
The item server.domain.local\DATABASE in use - skipped.
Backup- server.domain.local V-79-57344-33938 -
An error occurred on a query to database DATABASE.
V-79-57344-33938 - Exclusive access could not be obtained because the
database is in use.
If I do a log backup from SQL Server 2005 itself, backup is running fine
without errors.
What am I doing wrong ? Have I misunderstood the way Backup Exec and log
backup works ?
Thanks in advance,
:-) Jens
.
Relevant Pages
- Re: Backing up transaction logs gives poor performance.
... I have a problem with SQL server being very slow to access and use while I'm backing up transaction logs. ... On one of the apps there's a database with a 11.5GB .mdf file, ... Transaction log backup files from this database are typically about 20MB while the application is busy. ... The users of both apps complain of the same problem - intermittent slowness so bad it sometimes makes the app unusable. ... (microsoft.public.sqlserver.setup) - inusual reindexing behavior in SQL 2000
... We have SQL 2000 standard edition installed on windows ... It would appear that the database ... 7GB transaction log backup using ApexSQL Log reader. ... Is there any other reason that the database would be reindexed without ... (microsoft.public.sqlserver) - Re: How to "undo" a delete with cascades
... > Somebody accidently deleted a record with cascade deletes ... > is how to restore the database to a point in time. ... > (We do a full backup every week and log backup every day) ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (comp.databases.ms-sqlserver) - Re: 1105 - log file getting full - SQL Server 6.5
... I feel that you have the database option "Truncate log of check point" ... is turned off you have to perform the Transaction log backup to clear the ... perform tranaction log backup in frequent intervals. ... (microsoft.public.sqlserver.server) - RE: Humongous transaction log file - Repost! - URGENT!
... When the database restored, verfy the recovery modell, I think, You use "Full". ... Perform the log backup periodically on maintenance plan. ... Now when I tried to restore the database from a Database maintenance Plan ... (microsoft.public.sqlserver.server) |
|