Backup process hanging?

Hi everybody
OS is Win2000 with latest SP.
Microsoft SQL Server 7.00 - 7.00.842.
The problem is that there is a backup-process that is
runnable but wont finish or timeout. When i am trying to
kill the process nothing happens. It is still there!?!
Can someone maybe give some pointers to what i should do
to get ride of this process.
As it is now i cannot take a backup of the database the
backup process is hanged on.
/Risun
Hi,
From the SQL Server machine, Open Query Analyzer and execute the below
comamnd and see whether it suceeds.
Ensure that an existing Backup process is not going on.
BACKUP database <dbname> to disk='d:\backup\dbname.bak' with init , stats=10
Init parameter will overwrite the backup filr every time and stats=10 , will
show the percentage completed.
Note:
See the CPU and Memory usage of server.
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun
|||Ehh, but the problem is that the previous backup-process
will not die/go away/disappear. I have tried to kill the
process from the EM and with T-sql. It still remains.
The solution i am trying to avoid is stopping and starting
the MSSQLSERVER service. But as it is now i cannot see
another solution.
Trying to take a backup isnt possible as long as this
process is still alive.
Please, how can i kill this sucker.
/Risun

>--Original Message--
>Hi,
>From the SQL Server machine, Open Query Analyzer and
execute the below
>comamnd and see whether it suceeds.
>Ensure that an existing Backup process is not going on.
>BACKUP database <dbname> to disk='d:\backup\dbname.bak'
with init , stats=10
>Init parameter will overwrite the backup filr every time
and stats=10 , will
>show the percentage completed.
>Note:
>See the CPU and Memory usage of server.
>--
>Thanks
>Hari
>MCDBA
>"Risun" <risun@.wmdata.com> wrote in message
>news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
>
>.
>
|||If you can not kill it from SQL, you might try to kil the process from Task
manager, but I suspect you will have to stop/start SQL Server service..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Risun" <risun@.wmdata.com> wrote in message
news:1f69101c45781$a986adb0$a001280a@.phx.gbl...
> Hi everybody
> OS is Win2000 with latest SP.
> Microsoft SQL Server 7.00 - 7.00.842.
> The problem is that there is a backup-process that is
> runnable but wont finish or timeout. When i am trying to
> kill the process nothing happens. It is still there!?!
> Can someone maybe give some pointers to what i should do
> to get ride of this process.
> As it is now i cannot take a backup of the database the
> backup process is hanged on.
> /Risun
|||Hi,
If you kill the BACKUP process mostly that process will not be removed from
the process list. The only solution is to stop and start the MSSQL Server
service.
Why do you need to kill the backup process. Use my previous post (BACKUP
DATABASE) command
to backup the database. STATS=10 parameter will give you the percentage of
backup completed.
INF: Understanding How the Transact-SQL KILL Command Works
http://support.microsoft.com/default...microsoft.com:
80/support/kb/articles/Q171/2/24.ASP&NoWebContent=1
Thanks
Hari
MCDBA
"Risun" <risun@.wmdata.com> wrote in message
news:1ef1e01c4578c$55d2e8e0$a301280a@.phx.gbl...[vbcol=seagreen]
> Ehh, but the problem is that the previous backup-process
> will not die/go away/disappear. I have tried to kill the
> process from the EM and with T-sql. It still remains.
> The solution i am trying to avoid is stopping and starting
> the MSSQLSERVER service. But as it is now i cannot see
> another solution.
> Trying to take a backup isnt possible as long as this
> process is still alive.
> Please, how can i kill this sucker.
> /Risun
> execute the below
> with init , stats=10
> and stats=10 , will