dbTalk Databases Forums  

Any side effects from backing up DB and log at the same time?

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss Any side effects from backing up DB and log at the same time? in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oskar
 
Posts: n/a

Default Any side effects from backing up DB and log at the same time? - 12-16-2005 , 07:13 AM






Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?

What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?

-- Many, thanks. Oskar.

Reply With Quote
  #2  
Old   
David J. Cartwright
 
Posts: n/a

Default Re: Any side effects from backing up DB and log at the same time? - 12-16-2005 , 11:38 AM






in simple rm t-log backup useless

"Oskar" <Oskar (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
Do you know of any other possible dangers, apart from transaction log
backup
not being made and waiting for the full DB backup to complete, when
letting
the transaction log backup run during the full DB backup?

What else besides the failing transaction log backup can happen when
making
the backup during the time the database is in simple recovery mode?

-- Many, thanks. Oskar.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.