April 22, 2009 at 11:25 am
We are trying to restore a database that is in Full Recovery Mode. The first step we take is to back up the tail of the transaction log. However, an error is generated. The full text of the error follows:
Backup failed for Server 'server1'. (Microsoft.SqlServer.Smo)
Additional information:
System.Data.SqlClient.SqlError: BACKUP cannot process database 'test_1' because it is in use by this session. It is recommended that the master database be used when performing this operation. (Microsoft.SqlServer.Smo)
There are no active sessions either in Management Studio or through the application using this database (per verification through Activity Monitor.)
Has anyone seen this behavior before? What are we missing?
Thanks,
Kay
April 22, 2009 at 11:46 am
are YOU connected to the database when issuing the command?
---------------------------------------------------------------------
April 22, 2009 at 11:51 am
Only in the sense that I'm in Management Studio, and right-click on the database to select the backup task to back up the tail of the transaction log.
April 22, 2009 at 12:02 pm
Rather try doing the backup from a query window. Have object explorer disconnected.
Backup log ... to disk ... WITH NO_truncate, no_recovery
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply