February 27, 2007 at 5:49 pm
We purchased a custom application using SQL 2000 as back-end. The database recovery is Full. However there is no need to do a log backup. The scheduled maintenence job does a BACKUP LOG WITH NO_LOG every morning. Will it help I/O performance of the log if the database recovery mode is changed to simple? I am quite sure it will help because the server doesn't need to log everything in simple mode. However I 'd like to confirm with you guys. Thanks for the input.
February 27, 2007 at 6:13 pm
How do you recover in the middle of the day without having the logs in full recovery?
February 27, 2007 at 6:21 pm
We don't have the need to do log backup. Nightly full backup is enough.
The database is part of the custom app we puchased including SQL server and IIS server. The seller did the installation and set up so it is just as is.
February 27, 2007 at 6:25 pm
What I'm understanding is that you can afford to lose a full day's worth of data. If this is the case then you can switch to simple recovery and that will defenitly save some work for the hds. But make sure you really can afford that loss before taking that step. There's no turning back once it's done and you need a point in time restore.
February 28, 2007 at 1:46 pm
Ninja..
I did not get your statement " there is no turning back once it's done" ? do you mean it cannot be switched back to full recovery mode once its changed to simple?
could you please broaden your explanation
February 28, 2007 at 1:52 pm
i think what he meant was no posibility to restore the database to a certain time using the log.
February 28, 2007 at 1:56 pm
got it... thanks hthan
February 28, 2007 at 2:20 pm
Precisely.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply