backup in SQL Server 2000 - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

backup in SQL Server 2000

Author

Topic

imilankovic
Starting Member

3 Posts

Posted - 2005-12-26 : 05:44:36

I am trying to set a backup of my database on every hour. I know I need to create a job first but I don't know how to create one! Can someone help me out, please ?

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2005-12-26 : 05:52:13

You can try this..
RightClick database to be backedup-->All Task-->BackupDatabase
In the SQLServer Backup Dialog Select Type of BackUp Complete | Differential
Specify Destination
Check the Schedule check box and edit the schedule as per ur requirement

karuna
Aged Yak Warrior

582 Posts

Posted - 2005-12-26 : 05:52:16

Create a maintenance plan and schedule it to take backup every hour. To create a maintenance plan select the database in Enterprise Manager-> Right Click -> All Tasks->Maintenance Plan

Hope it helps

Thanks

Karunakaran

imilankovic
Starting Member

3 Posts

Posted - 2005-12-26 : 06:05:32

I did all that but it's still not working. Am I suppose to make som sort of connection between the maintenace plan and backup dialog box ?

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2005-12-26 : 06:19:51

These are the ways of doing the same task.
Did u try using backup database option?
In the same backup dialog box there is an option to schedule that task. once you scheduled that to run every hour.
Go to EM-->Management-->Sql ServerAgent(should be running)-->Jobs
you will find the backupjob listed over there.
select the job and start it.

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2005-12-26 : 06:39:59

Please post the error which you getting. You can get it from SQL SERVER LOGS or from even viewer.

Regards
Sachin

Don't sit back because of failure. It will come back to check if you still available. -- Binu

SamC
White Water Yakist

3467 Posts

Posted - 2005-12-26 : 08:51:38

If your database is of any size, you should consider investing in a backup program such as Idera or Red Gate. The GUI, data set compression and encryption options make it worth every penny.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources