I have SBS 2000, and Ineed to do the backup on line because we are woriking 7*24, and because of the size of DB, I need that the backup will be incremental, How can I do?
SQL Server backup operations are online by definition. To take incremental
backups, take a look at differential backups in books online.
Carlos E. Rojas
SQL Server MVP
Co-Author: SQL Server 2000 Programming by Example
"Martha esteban" <sistemas@.hilanderiafontibon.com> wrote in message
news:43E83FE9-C74D-4AED-A822-44E2AFE8C386@.microsoft.com...
> I have SBS 2000, and Ineed to do the backup on line because we are
woriking 7*24, and because of the size of DB, I need that the backup will
be incremental, How can I do?
|||Hi,
You can do a differential backup , this backup will perform backup on only
the data pages which is changed after your last backup. Prerequisite for
this is you should have FULL database backup.
BACKUP DATABASE <DBNAME> TO <DEVICE> WITH DIFFERENTIAL
Thanks
Hari
MCDBA
"Martha esteban" <sistemas@.hilanderiafontibon.com> wrote in message
news:43E83FE9-C74D-4AED-A822-44E2AFE8C386@.microsoft.com...
> I have SBS 2000, and Ineed to do the backup on line because we are
woriking 7*24, and because of the size of DB, I need that the backup will
be incremental, How can I do?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment