Backup Strategy

I am a newbie to SQL.
I am running SQL 2000 on a SBS 2003 R2 box. What is the best way to make
sure our databases are backed up in the event of a data loss or a crash?
Thanks,
Rich
The easiest way is to create a maintenance plan using the SQL Enterprise
Manager.
Or you can create jobs that use T-SQL statement to backup the databases.
Always make sure that the backup's are stored on offline storage, eg another
server or tapes.
The best way depends or your businessneeds and databasesize.
Robert Hartskeerl, MCTS
http://hartskeerl.nl/blogs/robert/
"Rikellent" wrote:

> I am a newbie to SQL.
> I am running SQL 2000 on a SBS 2003 R2 box. What is the best way to make
> sure our databases are backed up in the event of a data loss or a crash?
> Thanks,
> Rich
|||Hello,
You could use the maintenence wizard to create a backup plan and schedule
it. But I had lot of issues with maintenanceplans and so i went for TSQL
backup
script and schedule it using SQL Server agent.
Take a look into the below article:-
http://www.microsoft.com/india/msdn/articles/185.aspx
Thanks
Hari
"Rikellent" <Rikellent@.discussions.microsoft.com> wrote in message
news:BB10385E-8923-4AF7-B5B8-75F7B44CD993@.microsoft.com...
>I am a newbie to SQL.
> I am running SQL 2000 on a SBS 2003 R2 box. What is the best way to make
> sure our databases are backed up in the event of a data loss or a crash?
> Thanks,
> Rich

Backup on line, incremental or decremental

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?