I am thinking in Changing my SQL Server 2000 and 2005 databases from simple recovery model to full recovery model.
It makes no sense that this databases are in simple recovery model.
Do i need to test my apps before changing afetr changing the recovery model?
I think that it is not necessary because it's just a change of recovery model, but still i would like your advice.
I have some bulk insert during the end of the day in this databases, i think that this was why the person that creted this databases let them in simple recovery model (for the log not to grow).
If i change to full recovery model but do regular transaction log backups the log will be at the same size as if it as in simple recovery model?