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 Schlüter 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
> 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!
> >|||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 ':
> 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!
> >|||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 ':
> 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!
> >|||No,Never send email,
any ideas?,guy!
Greg D. Moore (Strider) wrote:
> 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 ':
> > 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!
> > >|||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:
> > 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 Schl=FCter Persson
> Databaseadministrator / Systemadministrator