By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,934 Members | 1,692 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,934 IT Pros & Developers. It's quick & easy.

backup job hang

P: n/a
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!

Jul 26 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

wy*****@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!
Specifically, How long is a "long time"?

Did you view the maintenance plan history? What steps were executed?
Did each step compele successfully? How long did each step take?

I have seen problems where the backup step works but the delete old
backup step fails. It turned out we had pending patches on the server
and a reboot cleaned up the problem allowing the job to run cleanly all
the way through.

HTH -- Mark D Powell --

Jul 26 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.