2012年3月22日星期四

Disk Backup stuck..NEED HELP

SQL 2000, Windows 2000 Server. I went to backup a
database last night to an existing file, choosing append.
7 hours later, the backup is still only 2 bars completed.
I then chose to "cancel" the backup procedure so that I
could create another file...I hit cancel and the backup
dialog still states it is running...Can I go into task
manager and kill sqlserver process? Will this cause
undesired effects?
People need to write to thsi database and I need to back
it up before they do.
TIA!!!!
~PJTo establish wheter the backup is still active you could use sp_who2 active.
I suggest running your backup in query analyser rather than EM, you can then
see the percentages complete. The following reports every 1% complete.
BACKUP DATABASE msdb TO DISK = 'C:\msdb.bak' WITH INIT , STATS = 1
--
HTH
Ryan Waight, MCDBA, MCSE
"PJ" <p.jones@.xsb.com> wrote in message
news:0e6301c39256$80eb8fb0$a401280a@.phx.gbl...
> SQL 2000, Windows 2000 Server. I went to backup a
> database last night to an existing file, choosing append.
> 7 hours later, the backup is still only 2 bars completed.
> I then chose to "cancel" the backup procedure so that I
> could create another file...I hit cancel and the backup
> dialog still states it is running...Can I go into task
> manager and kill sqlserver process? Will this cause
> undesired effects?
> People need to write to thsi database and I need to back
> it up before they do.
> TIA!!!!
> ~PJ|||I also wen into EM from another server and tried killing
the processes related to this problem, though I received
no error when "killing" the process, those processes did
not stop...
TIA!
~PJ
>--Original Message--
>SQL 2000, Windows 2000 Server. I went to backup a
>database last night to an existing file, choosing
append.
>7 hours later, the backup is still only 2 bars
completed.
>I then chose to "cancel" the backup procedure so that I
>could create another file...I hit cancel and the backup
>dialog still states it is running...Can I go into task
>manager and kill sqlserver process? Will this cause
>undesired effects?
>People need to write to thsi database and I need to back
>it up before they do.
>TIA!!!!
>~PJ
>.
>|||Thanks on the suggestion of doing it via query analyzer,
from now on I will
.
I opened EM and I look under process info and I see there
are 2 things SPID52 has. Under database it shows (first)
no database context - (second)CV-0803, then under
command, It shows killed/rollback for both. Should I
wait? Can I kill SQL Server ? Can I reboot server? What
should I do? I am really really stuck.
TIA!!!
~PJ
>--Original Message--
>To establish wheter the backup is still active you could
use sp_who2 active.
>I suggest running your backup in query analyser rather
than EM, you can then
>see the percentages complete. The following reports
every 1% complete.
>BACKUP DATABASE msdb TO DISK = 'C:\msdb.bak' WITH INIT ,
STATS = 1
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"PJ" <p.jones@.xsb.com> wrote in message
>news:0e6301c39256$80eb8fb0$a401280a@.phx.gbl...
>> SQL 2000, Windows 2000 Server. I went to backup a
>> database last night to an existing file, choosing
append.
>> 7 hours later, the backup is still only 2 bars
completed.
>> I then chose to "cancel" the backup procedure so that I
>> could create another file...I hit cancel and the backup
>> dialog still states it is running...Can I go into task
>> manager and kill sqlserver process? Will this cause
>> undesired effects?
>> People need to write to thsi database and I need to
back
>> it up before they do.
>> TIA!!!!
>> ~PJ
>
>.
>

没有评论:

发表评论