Discussion in 'SQL Server Log Shipping' started by RAJENDRA, Jul 13, 2005.
Is it possible to set log shipping to master database ?if Yes how? if not why ?
Don't post your question more than once.
Well, MASTER database remain in simple recovery model. thatsfore logshipping is not aplicalble for it.(there could be other reasons also..like its a system database not user)
Do you seriously require to set log shipping for MASTER database???? why do you want this..may be someother process can help you instead of logshipping.
--An eye for an eye and everyone shall be blind
No only user databases which are not in SIMPLE recovery model can be get under log shipping schedule.
You can continue taking full backup for system databases and copy it in another server for contingency purposes.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Separate names with a comma.