Nevermind.
I managed to acquire it by other means and I even got it to work now.
I am posting this to save some other poor soul some time.....
The unfortunate restriction appears to be that: *no* (read-only) users are
allowed to be connected to the "warm/hot/standby" database for the
rollfoward process to work.
Having read BOL:
"In standby mode, the database is available for read-only operations, such
as database queries that do not attempt to modify the database. This allows
the database to be used for decision-support queries or DBCC checks, for
example."
I was hoping that the "restore log..... with standby =" will allow (idle,
read only) users remain connected to the database. Unfortunately the error
message is loud and clear :
"Server: Msg 3101, Level 16, State 1, Line 1
Database in use. The system administrator must have exclusive use of the
database to run the restore operation.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.?
Oh well, there is always next release 8^)
So, if the database is say, minutes behind the master copy then it is
*effectively* un-available for any read-only work.
Alternatively, if the database is, say, hours behind the master then it can
be used for read-only work during non-roll-forward periods, with appropriate
scheduling.
It still remains a very useful utility IMHO, but not as useful as I first
hoped.
Have I missed anything? Is anyone using SQL 7.0 log shipping utility in
production yet? Any comments?
thanks in advance
--
Yuri Budilov (always expressing personal opinions only)
Melbourne, Australia
| Thanks for a very quick reply, Ron
|
| I went to MSDN Member downloads area
| (http://msdn.microsoft.com/subscriptions/resources/subdwnld.asp) and
| unfortunately we, Australians, are at the bottom of the pile - only North
| America and Europe are supported at the moment.....Well, at least we get
| compensated in many other areas! 8^)
|
| It would be a pity if I have to fork out for MS-Press BORK 4.5 kit, since
I
| would expect MSDN Universal kit to cover it.....sigh. 8^(
|
| Thanks again.
| --
| Yuri Budilov (always expressing personal opinions only)
| Melbourne, Australia
| | Yuri,
| |
| | It's on the CD that comes with the MS Press BORK 4.5. Check the MSDN
| | Downloads area; I don't know if it's up there yet.
| |
| | Ron
| | Ron Talmage
| | SQL Server MVP, MCSD, MCP
| |
| | >Hi
| | >
| | >has anyone found the SQL7.0 log shipping kit/documentation on MSDN
| | Universal
| | >BORK/BO 4.5? We have just received our copy of MSDN Universal June 1999
| | >update and I could not find it anyplace. Is log shipping available on
| | >SQL7.0? Is it on MS-Web anyplace?
| | >
| | >thanks for any pointers
| | >--
| | >Yuri Budilov (always expressing personal opinions only)
| | >Melbourne, Australia
| | >
| | >
| |
| |
|
|
by