Back up database

Hi everyone,

I am working in a company where data is changed daily (IT department of a shopping center) where item prices change everyday, the quantity available in stock vary daily,...
What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) .

could u help me with some links or idea.
I was thinking of doing a full back up one time everyweek and daily I will do a differential backup?
is that the best solution?
Thanks.

The Backup and Restore Wizard is one of the best things in the product, create job schedules for your backups and it will run. I have covered most of your questions in this thread below. If you have more questions post again. Hope this helps.
http://forums.asp.net/1050678/showpost.aspx

Back button for drilldown reports

Hereâ's a good question for the knowledgeable: I have been experimenting with
drilldown reports (where a report item is linked to a â'Jump to Reportâ'
action). In the designer there is a nifty little button that allows me to
move back to the previous report (level). This button does not seem apparent
in the Report Manager.
Am I missing something? I realize that there is IEâ's â'backâ' button however
that does not always return me to the previous report. For example if I
toggle the visibility of an item the browserâ's â'backâ' button will return me
to the previous state (hidden) as opposed to back to the report from which
this one was called.Yeah, there isn't one. I just put a back hyperlink in the header and footer
of each page and made sure when going back it sets the parameters to
whatever the default values are or in some cases whatever they were set to
the last time that report was visited.
bob.
"Herman K" <HermanK@.discussions.microsoft.com> wrote in message
news:D08E3158-FB92-4828-A6A8-ABCAA702AE3A@.microsoft.com...
> Here's a good question for the knowledgeable: I have been experimenting
> with
> drilldown reports (where a report item is linked to a 'Jump to Report'
> action). In the designer there is a nifty little button that allows me to
> move back to the previous report (level). This button does not seem
> apparent
> in the Report Manager.
> Am I missing something? I realize that there is IE's 'back' button
> however
> that does not always return me to the previous report. For example if I
> toggle the visibility of an item the browser's 'back' button will return
> me
> to the previous state (hidden) as opposed to back to the report from which
> this one was called.
>