Activity overview
Latest activity by richardj
Hi Jason
Thanks for the reply.
The need for nightly full backup is...
a) With nightly index maintenance jobs the total size of the logs is equivalent to the size of the database, so a full restore might as well be taken.
b) I am not confident in a DR solution built upon thousands and thousands of transacation logs 24 hours a daya 365 days a year. However I would be confident in a nightly full restore solution plus tlogs throughout the day. The system I am working only needs to be recoverable during business hours 8am-8pm, so I have a 12 hour window to complete a full restore.
The TS issue is probably because the log shipping wizard is still executing. However I can't prove/disprove this.
I will keep you updated on my progress.
Regards
Richard / comments
Hi Jason
Thanks for the reply.
The need for nightly full backup is...
a) With nightly index maintenance jobs the total size of the logs is equivalent to the size of the database, so a full restore ...
newbie log ship console questions
Hi
Using the product (v5.2) for the first time today I set up log shipping of a 24GB db. I left the console for a couple of hours, came back and the UI was unresponsive. Left it another hour and it...