June 1, 2004 at 1:13 pm
Hi all,
Can anyone help me in this.
I have a database on the production server which has a recovery model set to Simple. Now I need to change the recovery model to Full in order to take an advantage of transaction log files for my log shipping.
Now I know, I can easily change the recovery model by going into the properties and then options tab and change it to Full by just selecting the dropdown list in SQL Server 2000 SP2.
But, my question is if I change it to Full recovery model, would it there be any issues that I should expecting?
I'll appreciate the help in this regards.
Thanx.
Muneeb
June 1, 2004 at 1:47 pm
Your transaction log will grow, so you will need to do:
1. make sure there is enough room for the log to grow
2. make sure you allow the log to grow by an appropriate size
3. do regular full backups and transaction log backups
-SQLBill
June 1, 2004 at 1:47 pm
The only 2 issues that you might run into are slower inserts, updates, deletes as everything will now get logged to the transaction log (this however should not be an issue provided that the log is on a different drive), and that if you don't backup the log that it could grow and eventually consume the disk, then cause a failure of any further inserts, deletes or updates against the database until you've truncated the log.
June 1, 2004 at 2:06 pm
Thanx SQLBill and Nicholas Cain for your thoughts. I appreciated. I find this forum really useful and helps me a lot if guys like you keep an eye on this forum and reply to the question. You guys are doing a great job. Keep it up.
So apart from the points you fellas have indicated, there should me no problem with my current database files and what all I have to do is go to the properties of the database and change the recovery model..Am I correct?
Please put some thoughts on this to.
Thanx a lot.
Muneeb.
June 2, 2004 at 4:21 am
June 2, 2004 at 7:20 am
I have changed recovery mode on my user databases with no problems. I have never had to switch it to single user mode. Just make the change.
However, you can NOT change the recovery mode for the Master database. It is ALWAYS SIMPLE.
-SQLBill
June 2, 2004 at 9:22 am
After you have changed the recovery model and scheduled t-log backups, be sure to do a full database backup. T-log backups will not start till the db has been backed up.
-Dave
June 2, 2004 at 11:07 am
Thanx for all the suggestions I got in this forum. I have changed the recovery model to Full and now I'm getting the logs as well...right now I'm monitoring my production server and it's working very well....thanx to you guys....
Muneeb.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply