Perry Whittle (3/2/2015)
New Born DBA (3/2/2015)
Restored with recoveryThe secondary database must be restored with either NORECOVERY or STANDBY.
1 more question I have regarding the log shipping.
This is how the primary DB is setup
Full Backup at 1:00AM every night and then transactional log backup between 02:00AM and 12:00AM and then at 1:00 AM full backup. Will it affect the log shipping job or this schedule is ok?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]