June 29, 2006 at 8:30 am
Are there any gotcha's involved in switching from Simple to Full Recovery Mode. It looks like all I need to do is change the mode, make a backup of the database and then write a job to backup the log files is that correct? thanks in advance.
June 29, 2006 at 8:36 am
It seems too easy to be true but this has worked for me consistently.
Even so when you have an oracle background.
June 29, 2006 at 8:42 am
Yep,
That's all there is too it. You don't need to backup the log but if you don't your log will grow and grow until it hits a limit.
June 29, 2006 at 9:53 am
Where do I set the frequency for Transaction Log writes. Someone else set up this database and they only write out the logs weekly (not much good to me), but I couldn't find where they set that. thanks
June 29, 2006 at 9:58 am
Hi
Are you doing the backups through the Database Maintenance Plans.
If yes then you need to go to the Transaction log tab and there u can set the frequesncy of the transaction log backups.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply