November 18, 2011 at 4:20 am
hello
this is my first attempt in setting up log shipping in sql 2008 64 bit.
and when i think i am finally there i get another error
System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo)
please can someone assist me.
thanks
sp
November 18, 2011 at 6:11 am
did this error occur when trying to restore a log backup? It just means someone or something is connected to the database and a restore needs exclusive use.
Make sure there are no connections to the database. There is an option in the logshipping wizard to kill connections before restoring a log backup.
---------------------------------------------------------------------
November 18, 2011 at 8:11 am
I have selected the option to log out all users.
and still get the error.
also get a pop up box with the following error:
Row index must be greater than or equal to zero and less than the number of rows.
Parameter name: nRowIndex
Actual value was 4. (Microsoft.SqlServer.GridControl)
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.Grid.GridControl.EnsureCellIsVisibleInternal(Int64 nRowIndex, Int32 nColIndex)
at Microsoft.SqlServer.Management.UI.Grid.GridControl.EnsureCellIsVisible(Int64 nRowIndex, Int32 nColIndex)
at Microsoft.SqlServer.Management.UI.ProgressReportControl.UpdateActionStatusMarshal(Int32 actionIndex, ProgressStatus status)
November 18, 2011 at 8:24 am
at what point do you get this error?
---------------------------------------------------------------------
November 18, 2011 at 1:51 pm
it fails at Restoring backup to secondary database
November 18, 2011 at 4:36 pm
try restarting SQL on the secondary
---------------------------------------------------------------------
November 19, 2011 at 6:06 pm
Are you initialising the database before setting up log shipping or during?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2011 at 8:32 pm
Try restarting SQL Server on secondary server & also see to it that u have proper permission on Backup & copy folders on Primary & DR servers.
Also choose the option of Disconnect users while restoring on secondary server
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply