October 29, 2003 at 5:43 am
When log shipping in SQL 2000, can the destination database still be accessed while the shipped log is being applied ?
October 29, 2003 at 6:12 am
Hi there
Sure can, the DB is in "standby" mode, with read-only access. I have an article coming soon with a custom solution for remote servers (requiring no linked servers). Also note that furher transaction logs can be applied to the DBMS without kicking off the users as well, so its an effecive reporting DB and DR solution.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 29, 2003 at 7:03 am
I'd be very interested in Chris's solution.
I've always understood that the database cannot be accessed during the actual restore of the transaction log, but can be accessed (if left in standby mode) in between restores. I was also under the impression that log restore will fail unless users are kicked off first.
October 30, 2003 at 12:11 am
Chris,
I'm with Ian. If you've got a way of making a standby continually readable throughout application of logs, I'm VERY interested. This has been asked for by a number of clients.
Cheers,
- Mark
Cheers,
- Mark
October 30, 2003 at 6:58 am
Hi guys
well damn, now you guys have me worried, Ill run some more tests on it, at present I only have 2 users accessing the DB during my log restores, its in preperation for a system cutover actually and will post the results if im proved drastically wrong tomorrow with 30+ active users! 🙂
The article is a week off, im back at University to pretend im 20 and have all my hair back 😉 so im a tad "busy" boozin, i mean, studying.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 30, 2003 at 7:56 pm
Ok guys, im completely W R O N G, see messages below. Ill never use cognos again to suffice all my testing...
Via EM you get "error 927: database xyz cannot be open, its im tje middle of a restore"
or
Executed as user: CORPSYS\SQLServerAdmin. Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] (Error 3101) RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
or
Executed as user: CORPSYS\SQLServerAdmin. Killing Users [SQLSTATE 01000] (Message 0) ----------------- [SQLSTATE 01000] (Message 0) Exclusive access could not be obtained because the database is in use. [SQLSTATE 42000] (Error 3101) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
October 31, 2003 at 2:31 pm
Thats correct. Its the downside of log shipping. If you want to query it (for reporting most commonly), look at using replication instead.
Andy
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply