Store Backup of DataBase autometically at a Time

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Store Backup of DataBase autometically at a Time

Author

Topic

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2006-11-23 : 03:13:24

Hi

I want to take backup of my database per day at a particular time
by System automatically .How can it.I am using sql server 2000.

Ranjeet Kumar Singh

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-23 : 03:21:20

You can schedule backup to occur at specific time through enterprise manager.

There is Schedule check box in the Backup database dialog box to define the schedule.

Harsh Athalye
India.
"Nothing is Impossible"

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2006-11-23 : 03:48:18

Hi

This give following Error at last Step

The SQLServerAgent on target Server'(LOCAL)' is Stoped.Make Sure it is running during the scheduled execution of this job.

Ranjeet Kumar Singh

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-23 : 04:29:24

The message is crystal clear about what the error source is.

Right click in Enterprise manager under Management folder, SQL Server Agent and click on Start.

Harsh Athalye
India.
"Nothing is Impossible"

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2006-11-23 : 04:46:05

what is LOcation (Path) of Management folder

Ranjeet Kumar Singh

ranjeetsingh_6
Posting Yak Master

125 Posts

Posted - 2006-11-23 : 05:03:04

oohhhh sorry i this is very little mistak i ask
LOcation (Path) of Management folder

i was thought other think

Thank you........

Ranjeet Kumar Singh

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-23 : 05:04:23

Open Enterprise Manager.
Expand Microsoft SQL Servers node.
Expand SQL Server group.
Locate your server (presumably name is same as your computer name)
Expand it.
You will see Management folder there (next to Data Transformation Services folder)

Harsh Athalye
India.
"Nothing is Impossible"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources