Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.
-
Shamim #1
Transaction Log
SQL 2K
Is it possible to apply TRANSACTION LOG to a database while another process
(SP) reading data from the same db.??
In my case, the job which applies 'Transaction Log' failed with an error
message
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3101: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database in use. The system administrator must
have exclusive use of the database to run the restore operation.
[Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation
terminating abnormally.
Once the process (SP) completed, hourly transaction log job start working ..
Any thoughts/Suggestions to handle this !!
Thx
Sh
Shamim Guest
-
WS-Transaction
I understand that 'WS-Transaction' is the standard for cross-webservice transaction management. Couple of questions :- 1) In what state of... -
Transaction Server 4.0
Dear all, Please let me know is Microsft Transaction Server 4.0 able to run on Windows 2003? Thanks -
Transaction id and transaction isolation
Hi Two questions. I am using Informix IDS 9.4 on Windows. 1. I would like to be able to get hold of the transaction id while still in the... -
transaction/session id in SE7.2
Hi I am using InformixSE7.2 (on linux) and have been trying to write a stored procedure which, amongst other things, gets hold of the session... -
Transaction
Within a procedure i create two connection RConnection for readonly operation WConnection for write operation on a DB. Associated with the...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
