SQL Server doesn't have incremental backups. We have Differential backups instead. A differential backup is all the changes since the last full backup.
Use the BACKUP DATABASE command just like you would to do a full backup but add in the DIFFERENTIAL flag.
<pre>BACKUP DATABASE YourDatabase TO DISK='D:PathToYourFile.bak' WITH DIFFERENTIAL</pre>
This can be done with any version and/or edition of Microsoft SQL Server.
You can then schedule this to run using a SQL Agent Job (SQL 2008+ doesn't include the Agent in the Express edition).
Last Wiki Answer Submitted: August 18, 2010 6:47 pm by Denny Cherry64,520 pts.