Julius.S


I have convert all databases to Full from Simple Recovery model.

As per documentation, it looks like simple.

Based on your experiences , do you think of any problem may come while doing this

Any impact on application performance after this

Is this work perferened to do when no body using system

Thanks





Re: Switch Simple to Full Recovery Model

Arnie Rowland


The only problem is that you will no longer be able to RESTORE up to the moment of failure. You will only be able to restore to the time of the last FULL BACKUP.

Should be NO impact on application performance.

Yes, ALL users will have to be out of the database in order to make the change.







Re: Switch Simple to Full Recovery Model

jason7655

Here's a good chart that explains it:
http://msdn2.microsoft.com/en-us/library/ms189275.aspx