We are using SQL 2000; WIN 2003 BaaN IV C4. regularly take sequential dump(ttaad4226m000) at 11pm daily. this will take complete BaaN backup.

If I want to take incremental backup or difference only how to perform.

Please advice.

Schedule full backups weekly from SQL Enterprise manager and daily schedule differential backups at night and log backups say every 15 mins. Remember to move the backups / logs out of the server in order to have the real advantage of the backups .

hi,
By default (if Baandb was created by the Baan installation process and not manually), the recovery model of Baan database is set to "Simple". If you are planning to use transaction log backup then, you have to change this to "Full".

sk