January 7, 2010 at 8:14 am
In Bulk recovery model can we take log backups?
January 7, 2010 at 8:19 am
A simple question like that can be found in the documantation, along with relevant details:
January 7, 2010 at 9:14 am
Pradyothana Shastry (1/7/2010)
In Bulk recovery model can we take log backups?
A straight answer is "Yes"
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 7, 2010 at 1:31 pm
Pradyothana Shastry (1/7/2010)
In Bulk recovery model can we take log backups?
It's not a question of whether you can or can't - it is a question of whether you must or must not.
In full or bulk-logged recovery models you MUST take regular scheduled transaction log backups. If you don't, then you will be back here asking why your log file is so large and how can you shrink it.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 7, 2010 at 2:19 pm
Gail published a very explanatory article at SSC:
http://www.sqlservercentral.com/articles/64582/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 8, 2010 at 12:40 am
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply