October 6, 2008 at 12:41 am
hi .i got one task abt changing recovery model from simple to full.for this i need to take approval from any one like ebr team and application team.all dbs are in production.If any one knows abt this please tell me clearly.i need to perform this task tomorrow.changing recovery model should effect any users.for this task to be perform full back up is necessary?
thank u alot.
October 6, 2008 at 5:56 am
Hi,
You can change the recovery model "on the fly", users do not have to log off during the change. No restart of MSSQL is required.
Make sure you implement a transaction log backup, or your logfile will become (very) large.
Wilfred
The best things in life are the simple things
October 6, 2008 at 12:50 pm
Make sure that you have enough free space for the transaction logs and keep monitoring for a few days on the transaction log size and the required frequency of taking log backup
[font="Verdana"]Thanks
Chandra Mohan[/font]
October 6, 2008 at 10:35 pm
Thank .i suggested this to my pm.but she did not give approval for me.once again thanks.
October 6, 2008 at 11:44 pm
Do you know why you have/want to change the recovery model? It seems you're stuck in a very strange situation.
The recovery model has to met with the company's recovery strategy. If your company can't allow to loose production data for say more than 1 hour, full recovery is a must (let them calculate how much it will cost in case of a restore from yesterday). Of course it will result in some additional actions by you, but hey, that's your job 😉
Make sure they are aware of this situation and the consequences of it.
Good luck!
Wilfred
The best things in life are the simple things
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply