Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Differntial backup

Status
Not open for further replies.

sujosh

Programmer
Nov 29, 2001
93
US
How can we do differntial backup in SQLServer? How is it ( I mean the process) different than the full backup?

Thanks
 
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.
 
THanks Nigel! Appreciate it.. I was searching inccorectly in BOL...

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top