I have backups that have been running nightly without issue for quite some
time. To minimize data loss in the event of a major server disaster I setup
log shipping. I want to know if I can continue to perform the nightly
backups or if this will interfere with the log file shipping. The nightly
backups are useful for lots of things we do but aren't entirely necessary.As long as these "nightly backups" aren't log backups then you should be fine. A database backup do
not empty the log, i.e..e., it do not affect your log backup chain sequence in any way.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Bishop" <nospam@.nospam.com> wrote in message news:uyk7Nf8qIHA.1952@.TK2MSFTNGP05.phx.gbl...
>I have backups that have been running nightly without issue for quite some time. To minimize data
>loss in the event of a major server disaster I setup log shipping. I want to know if I can
>continue to perform the nightly backups or if this will interfere with the log file shipping. The
>nightly backups are useful for lots of things we do but aren't entirely necessary.
>|||Thank You!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:E46D838C-19D6-4FAB-A7F1-53B91CE3B005@.microsoft.com...
> As long as these "nightly backups" aren't log backups then you should be
> fine. A database backup do not empty the log, i.e..e., it do not affect
> your log backup chain sequence in any way.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Bishop" <nospam@.nospam.com> wrote in message
> news:uyk7Nf8qIHA.1952@.TK2MSFTNGP05.phx.gbl...
>>I have backups that have been running nightly without issue for quite some
>>time. To minimize data loss in the event of a major server disaster I
>>setup log shipping. I want to know if I can continue to perform the
>>nightly backups or if this will interfere with the log file shipping. The
>>nightly backups are useful for lots of things we do but aren't entirely
>>necessary.
>
Sunday, February 19, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment