MSSQL: making full backup every 24 hours.

Question

Hi,

I am trying to make a backup of MSSQL from client side for some reasons. Although nsrsqlsv is set to incremental but it makes full backup up approximately every 24 hours with the following message.

[6704] [I ] 07/31/07 16:02:14 Last backup of database 'DB1' was not created using NMSQL Module.
Promoting the backup level to full.[6704] [I ] 07/31/07 16:02:15 Backing up DB1...

A strange thing is, the backup server is taking backup from many clients with same configuration but only a few clients are doing the full-backup.
I confirmed that recovery model of MSSQL is full. (If the model is not full it makes full backup every time not every 24 hours.)

The version of both of NW server and client is 7.4 Build 187, and MSSQL module is 5.0.0.154.
Please help.

Regards Yoshi

amediratta · Answer

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.

yoshi2 · Answer

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

bc9am · Answer

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).

yoshi2 · Answer

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......

ble1 · Answer

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

Fatmosh1 · Answer

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!

NetWorker

MSSQL: making full backup every 24 hours.

Was this post helpful?