September 27, 2006 at 10:36 am
I want to do log shipping for a production database. My standby server is
SQL server cluster which is hosting other production databases.
can standby server be used as production server for other applications.
if yes, what is the effect of log shipping on other databases on the stand by server
September 28, 2006 at 1:40 pm
a "standby" instance of a database is not an "active" copy. There is no technical reason why you can't do what you describe; but you will need a separate instance of SQL Server - i.e., separate from the one that is doing "production" work.
Hopefully you have some hardware that is not production to test this before doing something awful to production.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply