 | |
log shipping load failure
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
log shipping load failure -
07-01-2004
, 04:33 AM
#2
| |||
| |||
|
|
Hi guys, In my lodg shipping setup i selected the option terminate users in database. but if the database is open the restore is failing with following error. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL Server Driver][SQL Server]Exclusive access could not be obtained because the database is in use. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally. is it normal? as fars as i know with the above option selected it should terminate the users and restore succesfully. thanks Biju |
#3
| |||
| |||
|
|
-----Original Message----- Why do you have connections open to the read-only DB? What connections are open when this happens? "biju george" wrote: Hi guys, In my lodg shipping setup i selected the option terminate users in database. but if the database is open the restore is failing with following error. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL Server Driver][SQL Server] Exclusive access could not be obtained because the database is in use. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally. is it normal? as fars as i know with the above option selected it should terminate the users and restore succesfully. thanks Biju . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.