Re: Transaction Log
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 07/09/03
- Next message: Andrew J. Kelly: "Re: Views in one database that lock tables in anouther 2"
- Previous message: Gavin Kerr: "Views in one database that lock tables in anouther 2"
- In reply to: Shamim: "Transaction Log"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 9 Jul 2003 19:01:43 +0100
Hello, Shamim!
NO. There cannot be users in the DB when you go to do a restore.
-- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org : 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 !! --- Microsoft Outlook Express 5.50.4920.2300
- Next message: Andrew J. Kelly: "Re: Views in one database that lock tables in anouther 2"
- Previous message: Gavin Kerr: "Views in one database that lock tables in anouther 2"
- In reply to: Shamim: "Transaction Log"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
