Views

Do I have to do anything different for incremental backups?

This Wiki is brought to you by Backup Central, where you can find the Mr. Backup Blog, Forums, and a mailing list for each forum!

Backup FAQs Service Providers Backup Software Backup Hardware Backup Book Wiki Free Stuff Miscellaneous


I have no problem with full backups. I simply put "MSSQL:" as saveset and "nsrsqlsv" in the remote command field. I setup another client for this machine with "MSSQL:" as saveset but "nsrsqlsv -l incr". Unfortunately NSR complained with message:

Server: servername: saveset of MSSQL: would be specified by two 
clients with the name client-name in group group-name.

If you wish to make incremental backups of MSSQL databases, you need to make a specific saveset-entry in the client definition. So instead of

MSSQL:

You need to enter

MSSQL:master
MSSQL:msdb
MSSQL:database1
MSSQL:database2