It's very similar just that it backs up the pages that have changed since the last full backup. When restoring you restore the full backup then the last differential.
The backup statement is the same as the full backup but with differential in the with cause.
Have a look in bol.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.