MSSQL: making full backup every 24 hours.

An incr. is an incr. normally in case where transaction logging is enabled on SQL. Is there any difference between your other SQL servers and this one.

This one seems going straight...compares current modified date of SQL database with last backup date and backs up the database at level FULL even if incr. is set.

Thank you for the reply. Honestly I don't see any significant difference between normal MSSQL server and this one. hmm.

I've go the same problem and I think I've just figured it out.

For me I backup several databases on the same server, all of them apart from one db backup properly (incremental's when I ask for incremental), but one of them always does full backups.

It looks like this is caused by the database recovery mode being set to Simple rather than Full (in the Database Properties, and options tab).

Hi,

Sorry for the late reply since I was on holiday these days, and thank you for your reply.

The database recovery mode is Full (not Simple). According to some articles I needed to rebuild media database so I tried it but the problem still persists. hmm......

You are sure no other method (including SQL native exports/dumps) is used to backup this databased other than NW?

I am also having this issue. However, with mine, sometimes it does the incremental and sometimes it does the full. I can't figure out how it decides to do which. There is no other application backing up the databases and the recovery model is set to Full.

Any other thoughts or insight would be appreciated.

Thanks!