Manual backup not starting

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.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.
>|||Hari,
OK, I am currently running the query to backup. It has been running for 7
minutes so far. I'll let you know when I see any messages or it completes.
Thanks,
Bill
"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.
> >
> >
>|||Just like the Energizer Bunny....still going and going and going.... 1
hour 6 minutes, still not responding in Query Analyzer. I've never run
across this problem. I've backed this database up many times before with no
problem.
"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.
> >
> >
>|||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.
> >
> >
>|||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.
> > >
> > >
> >
> >
>