Comments
Sort by recent activity
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 ...