backup job hang

hi,everyone!
I meet strange thing when I create a maintance job for backup all
database.
and this backup job just stands "Executing job step '(step 1)'" for a
very
long time .
SQL server startup account is this account for network bakcup
after I issue sp_databases sp, I found my full database size only 1GB,
and I found my backupfile is complete.
I view event log and Sql server Log and no found error!
why do it take so long time, but stands 'executing ' status and never
finish.
help me!
best regards!Hi
Slow network? Any other activities during the BACKUP?
<wyys.cn@.gmail.com> wrote in message
news:1153878873.514675.134860@.m79g2000cwm.googlegroups.com...
> hi,everyone!
> I meet strange thing when I create a maintance job for backup all
> database.
> and this backup job just stands "Executing job step '(step 1)'" for a
> very
> long time .
> SQL server startup account is this account for network bakcup
> after I issue sp_databases sp, I found my full database size only 1GB,
> and I found my backupfile is complete.
> I view event log and Sql server Log and no found error!
> why do it take so long time, but stands 'executing ' status and never
> finish.
>
> help me!
> best regards!
>|||wyys.cn@.gmail.com wrote:
> hi,everyone!
> I meet strange thing when I create a maintance job for backup all
> database.
> and this backup job just stands "Executing job step '(step 1)'" for a
> very
> long time .
> SQL server startup account is this account for network bakcup
> after I issue sp_databases sp, I found my full database size only 1GB,
> and I found my backupfile is complete.
> I view event log and Sql server Log and no found error!
> why do it take so long time, but stands 'executing ' status and never
> finish.
>
> help me!
> best regards!
>
If you see this in Enterprise Manager, do you then remember to Refresh
the job status?
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||nework speed is normal.
more strange thing,I found backup file is finish,but status is still
'Executing'
Uri Dimant =E5=86=99=E9=81=93=EF=BC=9A
[vbcol=seagreen]
> Hi
> Slow network? Any other activities during the BACKUP?
>
>
> <wyys.cn@.gmail.com> wrote in message
> news:1153878873.514675.134860@.m79g2000cwm.googlegroups.com...|||Click on Refresh in the EM
<wyys.cn@.gmail.com> wrote in message
news:1153897201.723900.209890@.75g2000cwc.googlegroups.com...
nework speed is normal.
more strange thing,I found backup file is finish,but status is still
'Executing'
Uri Dimant ':
[vbcol=seagreen]
> Hi
> Slow network? Any other activities during the BACKUP?
>
>
> <wyys.cn@.gmail.com> wrote in message
> news:1153878873.514675.134860@.m79g2000cwm.googlegroups.com...|||Is it trying to send an email at the end?
<wyys.cn@.gmail.com> wrote in message
news:1153897201.723900.209890@.75g2000cwc.googlegroups.com...
nework speed is normal.
more strange thing,I found backup file is finish,but status is still
'Executing'
Uri Dimant ':
[vbcol=seagreen]
> Hi
> Slow network? Any other activities during the BACKUP?
>
>
> <wyys.cn@.gmail.com> wrote in message
> news:1153878873.514675.134860@.m79g2000cwm.googlegroups.com...|||No,Never send email,
any ideas?,guy!
Greg D. Moore (Strider) wrote:[vbcol=seagreen]
> Is it trying to send an email at the end?
>
> <wyys.cn@.gmail.com> wrote in message
> news:1153897201.723900.209890@.75g2000cwc.googlegroups.com...
> nework speed is normal.
> more strange thing,I found backup file is finish,but status is still
> 'Executing'
>
> Uri Dimant ':
>|||i have refreshed staus, but it still stands 'executing',
I think it should have another cause.
Steen Persson (DK) wrote:
> wyys.cn@.gmail.com wrote:
> If you see this in Enterprise Manager, do you then remember to Refresh
> the job status?
>
> --
> Regards
> Steen Schl=FCter Persson
> Databaseadministrator / Systemadministrator