Prev: ALTER TABLE and ANSI_WARNINGS
Next: Deploy a DDL trigger to prevent dropping tables for mulitple datab
From: Mark on 6 May 2010 08:46
Verdict:
* Multiple Rows Returned
* HasBulkLoggedData = 0

Thank you to both of you! Very useful and interesting information. My log
backups were appending. I have added WITH INIT to overwrite the old file.
From: Chris Wood on 6 May 2010 10:57
Mark,

Not sure that you want to overwrite the backup file if you ever need to
recover fully. Best to create a new file each time and have the backup
delete the oldest ones once they are no longer needed. I.E. after a new full
backup is taken.

Chris

"Mark" <Mark(a)discussions.microsoft.com> wrote in message
news:F633FAEC-DFEE-457E-9DF9-C367691EF44A(a)microsoft.com...
> Verdict:
> * Multiple Rows Returned
> * HasBulkLoggedData = 0
>
> Thank you to both of you! Very useful and interesting information. My
> log
> backups were appending. I have added WITH INIT to overwrite the old file.


First  |  Prev  | 
Pages: 1 2
Prev: ALTER TABLE and ANSI_WARNINGS
Next: Deploy a DDL trigger to prevent dropping tables for mulitple datab