Thursday, March 22, 2012

database backup schedule not working

I'm running SQL server 2000 on a Windows Server 2003. I'm trying to schedule
a backup for my databases but it's not sticking. I went under Backup
Database, selected the local disk as a backup destination, clicked on
Schedule and setup my schedule.
Everything looks fine until I say OK and then if I go back to Backup
Database, the schedule is gone.
Expand the Management folder within Enterprise Manager
Open up the SQL Server Agent node
Navigate to the Jobs node
Right-click and choose "New Job"
give the job a name
on the steps tab give the job one (Transact-SQL) step as follows
BACKUP DATABASE master TO DISK = 'c:\master.bak' WITH INIT
hit ok
On the schedules tab hit "New Schedule"
specify the schedule to run.
You can wait for the job to run according to the schedule or you can
right-click on the job and choose "Start Job"
You will want to backup your user databases, master, and model. You will
probably want to choose a backup location other than C. Also, make sure
that you move the files to tape or to another server for safe keeping.
Keith
"Gilbert" <Gilbert@.discussions.microsoft.com> wrote in message
news:AB1E8EBA-62D0-4877-A974-1D5704379665@.microsoft.com...
> I'm running SQL server 2000 on a Windows Server 2003. I'm trying to
schedule
> a backup for my databases but it's not sticking. I went under Backup
> Database, selected the local disk as a backup destination, clicked on
> Schedule and setup my schedule.
> Everything looks fine until I say OK and then if I go back to Backup
> Database, the schedule is gone.
sql

No comments:

Post a Comment