Re: backup not working

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 21:19:18 +0530

Hi,

Check "SQLServer Agent" service is running. If not start the service and
check if the schedule is working.

What is the best option to take complete backup. Should I append to the
media or overwrite?

Both options are fine, But due to hard disk space limitations mostly people
choose the overwrite options (WITH INIT).
But ensure that old backup file is copied / moved to a remote hard disk or
Tape before overwriting.

Thanks
Hari
MCDBA

"Linda" <anonymous@discussions.microsoft.com> wrote in message
news:1931e01c44ca6$7bc051a0$a501280a@phx.gbl...
> In Enterprise Manager, I created a schedule to backup the
> database. But the database is not being backed up.
> I am able to manually take backup of my database.
>
> What is the best option to take complete backup.
> Should I append to the media or overwrite?
>
> Thank you in advance,
> Linda

Relevant Pages

  • Re: backing up sql server DB nightly
    ... There are 2 options to schedule a backup of database. ... Maintenance plans use SQL agent to schedule so ensure that SQL Agent service ...
    (microsoft.public.sqlserver.programming)
  • Re: database backup schedule not working
    ... On the schedules tab hit "New Schedule" ... You will want to backup your user databases, master, and model. ... > I'm running SQL server 2000 on a Windows Server 2003. ... > Database, selected the local disk as a backup destination, clicked on ...
    (microsoft.public.sqlserver.tools)
  • Re: mount database with *.edb and all logs Exchange 2007 urgent :>
    ... Then If I enable that option in EMC under properties of the store(Allow ... and i think the best solution is the allow backup to overwrite, ... when i want a new database with the path of the *.edb file it show me the ...
    (microsoft.public.exchange.admin)
  • SQL Server Agent permissions
    ... I am trying to schedule backup jobs - seemingly very simple however, ... If I look at the "Display Error Log" when right-click on SQL Server Agent it ... username is invalid for database 'master'. ...
    (microsoft.public.sqlserver.setup)
  • Re: backup not working
    ... >check if the schedule is working. ... >What is the best option to take complete backup. ... >choose the overwrite options. ... But the database is not being backed up. ...
    (microsoft.public.sqlserver.server)