Re: Manual backup not starting

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 15:52:50 -0500

You may have had an old log or full backup that was blocking the first
backup. That happens sometimes. sp_who2 will show any blocking SPIDs. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Bill" <wbeatty@prodigy.net> wrote in message
news:eA21dDw%23DHA.1796@TK2MSFTNGP12.phx.gbl...
> Well.....I couldn't take it any more.   I rebooted the server, and now
> everything is working fine.....who knows!  Now the backup completed in 2
> minutes.  I couldn't find any other jobs that were interfering, everything
> looked great, but the goofy thing wouldn't back up.
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
> news:eY0kBPv#DHA.1844@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > Can you please try the below command from Query analyzer to backup the
> > database.
> >
> > Backup database dbname to disk='c:\backup\dbname.bak' with init,
stats=10
> >
> > Replace the dbname and drive letter based on your requirement.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> > "Bill" <WBeatty@Prodigy.Net> wrote in message
> > news:eeRyb8u#DHA.3496@TK2MSFTNGP10.phx.gbl...
> > > I am trying to run a manual backup of a database in SQL Server 2000,
as
> > I've
> > > done many times in the past.  This database is over 4 Gb.  The backup
> says
> > > it is in progress, but I never see any "progress".   It has been
sitting
> > > like this for over an hour, and the machine is only using 1% of it's
> > > resources and has plenty of free memory.
> > >
> > > Does anyone have any ideas why this is happening?  Thanks.
> > >
> > >
> >
> >
>
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... with volume Shadow Copy error 800423f4. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.server)
  • Re: Start SQLServerAgent job Synchronously
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > call and the caller resumes processing as soon as the call is made. ... > I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: "Best Practices" way to distribute MSDE
    ... > Restore a users's selected backup. ... for dayly house-keeping I do usually provide scripted job for database ... that file copy operation (not SQL Server backup!) can be performed.. ... my personala advice is to perform dayly house-keeping actions ...
    (microsoft.public.sqlserver.msde)
  • Re: NT Backup Causes Server to Hang
    ... Thanks for using the SBS newsgroup. ... You back up data from a volume that contains a Microsoft SQL Server ... The recovery model of the SQL Server database is configured to use an ... It just ensures backup will continue without reporting the error. ...
    (microsoft.public.windows.server.sbs)
Loading