Procmeister (8/15/2013)
- Once I've done that how does it work? Will I see new jobs setup? Is a new database created? Will I be able to get an email if shipping fails?
Yes
- Can shipping work effectively at 5 minute intervals? Both servers are local, in the same building.
Yes
- Will all the databases on the standby server be marked with a "read-only" or other status?
Yes, if you set it for Standby. Restoring (unavailable) otherwise
- If the primary server fails:
- What steps do I take to make the standby server active?
- If the standby becomes active and inserts/updates/deletes occur, what steps do I take to propagate the activity over to the primary server once it is active again?
Pretty much the same steps you'd take if you were doing this all manually, restore the standby with recovery, then restore log backups back to principal once it comes back
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability