I'm thinking of using DPM 2007 exclusively for backup of our SQL Server
databases. I'm assuming that even thought the data is protected by DPM, I
would still need to run log backups (perhaps with the NO_LOG option?) in
order to truncate the log files and keep them from growing too large. Is
this assumption correct?Hi Steve
Assuming you have full or bulk-logged recovery models! Log backups will free
up the inactive portion of the log file and allow it to be re-used,
therefore the size of the log file should remain a constant size if you
perform log backups regularly, unless you do something unusual. There should
be no need to shrink the files as shrinking database files can lead to disc
fragmentation and performance issues.
The NO_LOG and NO_TRUNCATE options should not be included as these break the
back chain.
John
"steveg" <steveg@.discussions.microsoft.com> wrote in message
news:96651CBC-4433-4D7A-99C5-3EB9FBCCC791@.microsoft.com...
> I'm thinking of using DPM 2007 exclusively for backup of our SQL Server
> databases. I'm assuming that even thought the data is protected by DPM, I
> would still need to run log backups (perhaps with the NO_LOG option?) in
> order to truncate the log files and keep them from growing too large. Is
> this assumption correct?
--== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--
No comments:
Post a Comment