sql backup files: hang

Showing posts with label hang. Show all posts

Monday, February 13, 2012

Backup jobs hang :((

Hi,
propably asked and answered in the past, but cannot find anything on this
question.
Problem :
SQL70 latest SP , DB Maintenance plan backups hung
the jobagent says the first step is running and still nothing happens.
I have recreated the jobs tis helps for a day or two. Then the s--t hits the
fan again. Backup jobs hang
Jobs are running around 0100 am and there is NO activity in the DBs at that
time so it shouldnt be a blocking problem :(
Any ideas , anybody. Help would be appreciated very much.
--
IT-Manager
Mandatum Stockbrokers Ltd.
Remove _POISTA_ from address to replyWhat does sp_who, sp_who2, Current Activity etc say. Is the command (BACKUP, I take it) executing?
Etc.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
news:OQLxaMulDHA.1096@.TK2MSFTNGP11.phx.gbl...
> Hi,
> propably asked and answered in the past, but cannot find anything on this
> question.
> Problem :
> SQL70 latest SP , DB Maintenance plan backups hung
> the jobagent says the first step is running and still nothing happens.
> I have recreated the jobs tis helps for a day or two. Then the s--t hits the
> fan again. Backup jobs hang
> Jobs are running around 0100 am and there is NO activity in the DBs at that
> time so it shouldnt be a blocking problem :(
> Any ideas , anybody. Help would be appreciated very much.
>
> --
> IT-Manager
> Mandatum Stockbrokers Ltd.
> Remove _POISTA_ from address to reply
>|||Hi Tibor, and thanks for the reply
Heres some additional info
Backup command runs without a glitch when executed from EM or from SQA.
Backups can be sent without probs to tape, disk, remote share. WOrks like a
dream when done manually. EVEN during the day when there is LOT of activity
in the DB.
The DB main jobs are run at night.
EM->Management->Job Agent
"DB backup job for DB main... status:Executing Job Step '1 (step 1)'
Current activity, shows
17 RUNNABLE sa MDTSQL05 .
master EXECUTE 0 0 10/15 02:00:00 SQLAgent - TSQL JobStep (Job 0 17
18 RUNNABLE sa MDTSQL05 .
master EXECUTE 0 0 10/12 00:00:00 SQLAgent - TSQL JobStep (Job 0 18
19 RUNNABLE sa MDTSQL05 .
master EXECUTE 0 0 10/19 00:00:00 SQLAgent - TSQL JobStep (Job 0 19
for the job in question
(properties of session )
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
FAC0296F-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpOnlyIfC
lean -CkDB -BkUpMedia DISK -BkUpDB "I:\Databak" -DelBkUps
1DAYS -CrBkSubDir -BkExt "BAK"'
Nothing is happening. status runnable
The backup jobs is scheduled at 0200
I have two jobs (or plans)
The other one does this Backup stuff and the other backs up DB-logs every 10
minutes
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
FAC02972-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpMedia
DISK -BkUpLog "I:\LogBak" -DelBkUps 2DAYS -CrBkSubDir -BkExt "TRN"'
This schedule is run between 0700 - 2300 hours,
So basically at the moment " I am up the ... creek without a paddle"
Restarting the server has helped or recreating the jobs but only for some
days.
Booting the server at 1 days interval is not an option
HELP :-O :))
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ugM19ZulDHA.424@.TK2MSFTNGP10.phx.gbl...
> What does sp_who, sp_who2, Current Activity etc say. Is the command
(BACKUP, I take it) executing?
> Etc.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
> news:OQLxaMulDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > propably asked and answered in the past, but cannot find anything on
this
> > question.
> >
> > Problem :
> > SQL70 latest SP , DB Maintenance plan backups hung
> > the jobagent says the first step is running and still nothing happens.
> >
> > I have recreated the jobs tis helps for a day or two. Then the s--t hits
the
> > fan again. Backup jobs hang
> > Jobs are running around 0100 am and there is NO activity in the DBs at
that
> > time so it shouldnt be a blocking problem :(
> >
> > Any ideas , anybody. Help would be appreciated very much.
> >
> >
> > --
> > IT-Manager
> > Mandatum Stockbrokers Ltd.
> >
> > Remove _POISTA_ from address to reply
> >
> >
>|||Masa
Are you sure that during nightly backup there are not some others activites
on the server ?
"MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
news:OEqSa4ulDHA.1800@.TK2MSFTNGP10.phx.gbl...
> Hi Tibor, and thanks for the reply
> Heres some additional info
> Backup command runs without a glitch when executed from EM or from SQA.
> Backups can be sent without probs to tape, disk, remote share. WOrks like
a
> dream when done manually. EVEN during the day when there is LOT of
activity
> in the DB.
> The DB main jobs are run at night.
> EM->Management->Job Agent
> "DB backup job for DB main... status:Executing Job Step '1 (step 1)'
> Current activity, shows
> 17 RUNNABLE sa MDTSQL05 .
> master EXECUTE 0 0 10/15 02:00:00 SQLAgent - TSQL JobStep (Job 0 17
> 18 RUNNABLE sa MDTSQL05 .
> master EXECUTE 0 0 10/12 00:00:00 SQLAgent - TSQL JobStep (Job 0 18
> 19 RUNNABLE sa MDTSQL05 .
> master EXECUTE 0 0 10/19 00:00:00 SQLAgent - TSQL JobStep (Job 0 19
>
> for the job in question
> (properties of session )
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
>
FAC0296F-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpOnlyIfC
> lean -CkDB -BkUpMedia DISK -BkUpDB "I:\Databak" -DelBkUps
> 1DAYS -CrBkSubDir -BkExt "BAK"'
> Nothing is happening. status runnable
> The backup jobs is scheduled at 0200
>
> I have two jobs (or plans)
> The other one does this Backup stuff and the other backs up DB-logs every
10
> minutes
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> FAC02972-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpMedia
> DISK -BkUpLog "I:\LogBak" -DelBkUps 2DAYS -CrBkSubDir -BkExt "TRN"'
> This schedule is run between 0700 - 2300 hours,
>
> So basically at the moment " I am up the ... creek without a paddle"
> Restarting the server has helped or recreating the jobs but only for some
> days.
> Booting the server at 1 days interval is not an option
> HELP :-O :))
>
>
>
>
>
>
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:ugM19ZulDHA.424@.TK2MSFTNGP10.phx.gbl...
> > What does sp_who, sp_who2, Current Activity etc say. Is the command
> (BACKUP, I take it) executing?
> > Etc.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
> > news:OQLxaMulDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > propably asked and answered in the past, but cannot find anything on
> this
> > > question.
> > >
> > > Problem :
> > > SQL70 latest SP , DB Maintenance plan backups hung
> > > the jobagent says the first step is running and still nothing happens.
> > >
> > > I have recreated the jobs tis helps for a day or two. Then the s--t
hits
> the
> > > fan again. Backup jobs hang
> > > Jobs are running around 0100 am and there is NO activity in the DBs at
> that
> > > time so it shouldnt be a blocking problem :(
> > >
> > > Any ideas , anybody. Help would be appreciated very much.
> > >
> > >
> > > --
> > > IT-Manager
> > > Mandatum Stockbrokers Ltd.
> > >
> > > Remove _POISTA_ from address to reply
> > >
> > >
> >
> >
>|||You didn't say which job of the two is failing, or whether both a re failing. Do a job ever succeed?
If so, I'd run a profiler trace and catch for which statement it hangs. Or, rather, run a trace
anyhow, you can compare to a similar job on another server.
What do you mean with "hang"? What does Agent say about the job status? Can you terminate with
Agent? Etc.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
news:OEqSa4ulDHA.1800@.TK2MSFTNGP10.phx.gbl...
> Hi Tibor, and thanks for the reply
> Heres some additional info
> Backup command runs without a glitch when executed from EM or from SQA.
> Backups can be sent without probs to tape, disk, remote share. WOrks like a
> dream when done manually. EVEN during the day when there is LOT of activity
> in the DB.
> The DB main jobs are run at night.
> EM->Management->Job Agent
> "DB backup job for DB main... status:Executing Job Step '1 (step 1)'
> Current activity, shows
> 17 RUNNABLE sa MDTSQL05 .
> master EXECUTE 0 0 10/15 02:00:00 SQLAgent - TSQL JobStep (Job 0 17
> 18 RUNNABLE sa MDTSQL05 .
> master EXECUTE 0 0 10/12 00:00:00 SQLAgent - TSQL JobStep (Job 0 18
> 19 RUNNABLE sa MDTSQL05 .
> master EXECUTE 0 0 10/19 00:00:00 SQLAgent - TSQL JobStep (Job 0 19
>
> for the job in question
> (properties of session )
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> FAC0296F-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpOnlyIfC
> lean -CkDB -BkUpMedia DISK -BkUpDB "I:\Databak" -DelBkUps
> 1DAYS -CrBkSubDir -BkExt "BAK"'
> Nothing is happening. status runnable
> The backup jobs is scheduled at 0200
>
> I have two jobs (or plans)
> The other one does this Backup stuff and the other backs up DB-logs every 10
> minutes
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> FAC02972-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpMedia
> DISK -BkUpLog "I:\LogBak" -DelBkUps 2DAYS -CrBkSubDir -BkExt "TRN"'
> This schedule is run between 0700 - 2300 hours,
>
> So basically at the moment " I am up the ... creek without a paddle"
> Restarting the server has helped or recreating the jobs but only for some
> days.
> Booting the server at 1 days interval is not an option
> HELP :-O :))
>
>
>
>
>
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:ugM19ZulDHA.424@.TK2MSFTNGP10.phx.gbl...
> > What does sp_who, sp_who2, Current Activity etc say. Is the command
> (BACKUP, I take it) executing?
> > Etc.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
> > news:OQLxaMulDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > >
> > > propably asked and answered in the past, but cannot find anything on
> this
> > > question.
> > >
> > > Problem :
> > > SQL70 latest SP , DB Maintenance plan backups hung
> > > the jobagent says the first step is running and still nothing happens.
> > >
> > > I have recreated the jobs tis helps for a day or two. Then the s--t hits
> the
> > > fan again. Backup jobs hang
> > > Jobs are running around 0100 am and there is NO activity in the DBs at
> that
> > > time so it shouldnt be a blocking problem :(
> > >
> > > Any ideas , anybody. Help would be appreciated very much.
> > >
> > >
> > > --
> > > IT-Manager
> > > Mandatum Stockbrokers Ltd.
> > >
> > > Remove _POISTA_ from address to reply
> > >
> > >
> >
> >
>|||In this context hang means "the job never finishes" :)
Both jobs fail (or actually are never completed). If I stop the agent the
job logs claim the job has finished properly and everything is ok . This is
not the truth. (trust no one ) LOL :)
Agent can be restarted without probs, no reboot needed to stop/start cycle.
the Jobs succeed couple of time if I recreate them from scratch. The
failures are happening only for this on database, the rest of DBs do get
backuped up without a glitch. Weird !
I killed the jobs today about an hour ago and now the job for trans-logs is
working although I am not at all sure when its gonna die again.
The Db backup will execute this night at 0200 hours. I just wish it is going
to execute properly.
Of course I could try to create a schedule on the server which then would
stop/start the Agent from OS level. Might work but would be a definite "hack
patch" . it would NOT fix the original disease just cure the symptoms LOL|||Hi Uri
There are two "listener"-programs on the server running.
1 is listening to a IBM.-MQ queue and reads message from the queue and
inserts stuff into db . The message are sent by our web site and the users
are retail clients. The logs show me there are NO messages coming this late
at night.
The other on polls the db and send execution information on the previously
mentioned messages.
No activity during the night.
And these progs have been running on this server for ages and this backup
prob has only been around for couple of months
rgrds Matti
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e$wWFAvlDHA.1408@.TK2MSFTNGP11.phx.gbl...
> Masa
> Are you sure that during nightly backup there are not some others
activites
> on the server ?
> "MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
> news:OEqSa4ulDHA.1800@.TK2MSFTNGP10.phx.gbl...
> > Hi Tibor, and thanks for the reply
> >
> > Heres some additional info
> >
> > Backup command runs without a glitch when executed from EM or from SQA.
> > Backups can be sent without probs to tape, disk, remote share. WOrks
like
> a
> > dream when done manually. EVEN during the day when there is LOT of
> activity
> > in the DB.
> >
> > The DB main jobs are run at night.
> >
> > EM->Management->Job Agent
> > "DB backup job for DB main... status:Executing Job Step '1 (step 1)'
> >
> > Current activity, shows
> > 17 RUNNABLE sa MDTSQL05
.
> > master EXECUTE 0 0 10/15 02:00:00 SQLAgent - TSQL JobStep (Job 0 17
> > 18 RUNNABLE sa MDTSQL05
.
> > master EXECUTE 0 0 10/12 00:00:00 SQLAgent - TSQL JobStep (Job 0 18
> > 19 RUNNABLE sa MDTSQL05
.
> > master EXECUTE 0 0 10/19 00:00:00 SQLAgent - TSQL JobStep (Job 0 19
> >
> >
> >
> > for the job in question
> >
> > (properties of session )
> >
> > EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> >
>
FAC0296F-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpOnlyIfC
> > lean -CkDB -BkUpMedia DISK -BkUpDB "I:\Databak" -DelBkUps
> > 1DAYS -CrBkSubDir -BkExt "BAK"'
> >
> > Nothing is happening. status runnable
> > The backup jobs is scheduled at 0200
> >
> >
> > I have two jobs (or plans)
> >
> > The other one does this Backup stuff and the other backs up DB-logs
every
> 10
> > minutes
> >
> > EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> >
FAC02972-DF1C-11D7-9A18-0002A528BED5 -WriteHistory -VrfyBackup -BkUpMedia
> > DISK -BkUpLog "I:\LogBak" -DelBkUps 2DAYS -CrBkSubDir -BkExt "TRN"'
> >
> > This schedule is run between 0700 - 2300 hours,
> >
> >
> > So basically at the moment " I am up the ... creek without a paddle"
> > Restarting the server has helped or recreating the jobs but only for
some
> > days.
> > Booting the server at 1 days interval is not an option
> >
> > HELP :-O :))
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "Tibor Karaszi"
> <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> > wrote in message news:ugM19ZulDHA.424@.TK2MSFTNGP10.phx.gbl...
> > > What does sp_who, sp_who2, Current Activity etc say. Is the command
> > (BACKUP, I take it) executing?
> > > Etc.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > Archive at: http://groups.google.com/groups?oi=djq&as
> > ugroup=microsoft.public.sqlserver
> > >
> > >
> > > "MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
> > > news:OQLxaMulDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > >
> > > > propably asked and answered in the past, but cannot find anything on
> > this
> > > > question.
> > > >
> > > > Problem :
> > > > SQL70 latest SP , DB Maintenance plan backups hung
> > > > the jobagent says the first step is running and still nothing
happens.
> > > >
> > > > I have recreated the jobs tis helps for a day or two. Then the s--t
> hits
> > the
> > > > fan again. Backup jobs hang
> > > > Jobs are running around 0100 am and there is NO activity in the DBs
at
> > that
> > > > time so it shouldnt be a blocking problem :(
> > > >
> > > > Any ideas , anybody. Help would be appreciated very much.
> > > >
> > > >
> > > > --
> > > > IT-Manager
> > > > Mandatum Stockbrokers Ltd.
> > > >
> > > > Remove _POISTA_ from address to reply
> > > >
> > > >
> > >
> > >
> >
> >
>|||> Both jobs fail (or actually are never completed).
That is a very big difference!!! I take it you mean never completes. :-)
> Of course I could try to create a schedule on the server which then would
> stop/start the Agent from OS level.
Sounds like too much of a hack to me, you really shouldn't need to do this. I again suggest you run
a profiler trace (include both starting as well as completed command events) to see at which command
it hangs. Also the current activity in EM can show you the command (as well as DBCC INPUTBUFFER).
This would need you to be at place when this happen, of course.
Btw, how long have you waited for the job to complete? Long enough?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
news:uazasLvlDHA.1800@.TK2MSFTNGP10.phx.gbl...
> In this context hang means "the job never finishes" :)
> Both jobs fail (or actually are never completed). If I stop the agent the
> job logs claim the job has finished properly and everything is ok . This is
> not the truth. (trust no one ) LOL :)
> Agent can be restarted without probs, no reboot needed to stop/start cycle.
> the Jobs succeed couple of time if I recreate them from scratch. The
> failures are happening only for this on database, the rest of DBs do get
> backuped up without a glitch. Weird !
> I killed the jobs today about an hour ago and now the job for trans-logs is
> working although I am not at all sure when its gonna die again.
> The Db backup will execute this night at 0200 hours. I just wish it is going
> to execute properly.
> Of course I could try to create a schedule on the server which then would
> stop/start the Agent from OS level. Might work but would be a definite "hack
> patch" . it would NOT fix the original disease just cure the symptoms LOL
>
>
>|||Long enough, I think a 12 hour period is long enough :D interactively driven
backups take about 1,5 hours, same amount of time goes for the execution
when the jobs work ie, very seldom LOL
I have to think about this crap and find a solution. Allthough we are
migrating our DBs to a new server and OS version in 2 weeks so this quirk
might just vanish at that point of time
I thank you for your assistance
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:#d6F19vlDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > Both jobs fail (or actually are never completed).
> That is a very big difference!!! I take it you mean never completes. :-)
>
> > Of course I could try to create a schedule on the server which then
would
> > stop/start the Agent from OS level.
> Sounds like too much of a hack to me, you really shouldn't need to do
this. I again suggest you run
> a profiler trace (include both starting as well as completed command
events) to see at which command
> it hangs. Also the current activity in EM can show you the command (as
well as DBCC INPUTBUFFER).
> This would need you to be at place when this happen, of course.
> Btw, how long have you waited for the job to complete? Long enough?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "MaSa" <matti.saukkonen@._ POISTA_ mandatum.fi> wrote in message
> news:uazasLvlDHA.1800@.TK2MSFTNGP10.phx.gbl...
> > In this context hang means "the job never finishes" :)
> >
> > Both jobs fail (or actually are never completed). If I stop the agent
the
> > job logs claim the job has finished properly and everything is ok . This
is
> > not the truth. (trust no one ) LOL :)
> >
> > Agent can be restarted without probs, no reboot needed to stop/start
cycle.
> >
> > the Jobs succeed couple of time if I recreate them from scratch. The
> > failures are happening only for this on database, the rest of DBs do get
> > backuped up without a glitch. Weird !
> >
> > I killed the jobs today about an hour ago and now the job for trans-logs
is
> > working although I am not at all sure when its gonna die again.
> >
> > The Db backup will execute this night at 0200 hours. I just wish it is
going
> > to execute properly.
> >
> > Of course I could try to create a schedule on the server which then
would
> > stop/start the Agent from OS level. Might work but would be a definite
"hack
> > patch" . it would NOT fix the original disease just cure the symptoms
LOL
> >
> >
> >
> >
> >
>|||Reboot the server..
From http://www.developmentnow.com/g/118_2003_10_0_0_464322/Backup-jobs-hang-.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

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!wyys.cn@.gmail.com wrote:

Quote:

Originally Posted by

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 --

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

backup job hang

Friday, February 10, 2012

backup hang

Hi All,
I have a problem with the backup hang. I make a backup
through EM, completed + verified as well. It doesn't
matter what location I choose. For this example, I used
the default backup SQL location on the same drive.
When I try to restore the backup, it starts, but the
dialogbox did not show progress and it stays there for
ever. In the errorlog I have the error:
udopen: Operating system error 32(The process cannot
access the file because it is being used by another
process.) during the creation/opening of physical device
D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
not open device D:\MRE-DEV-
SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
(VDN) 0.
What I could look at?
Thanks a lot for the help.Seems like you try to restore to a new database name but you don't specify for that database to be
created to use new filename, meaning that SQL Server tries to use the file names that are already in
use by the old database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"MJ" <MJ@.mjsql.com> wrote in message news:06b601c38f4d$f73930c0$a001280a@.phx.gbl...
> Hi All,
> I have a problem with the backup hang. I make a backup
> through EM, completed + verified as well. It doesn't
> matter what location I choose. For this example, I used
> the default backup SQL location on the same drive.
> When I try to restore the backup, it starts, but the
> dialogbox did not show progress and it stays there for
> ever. In the errorlog I have the error:
> udopen: Operating system error 32(The process cannot
> access the file because it is being used by another
> process.) during the creation/opening of physical device
> D:\MRE-DEV-SQL_data\MSSQL\Data\ENT_DATA.mdf.
> 2003-10-09 15:09:30.67 spid58 FCB::Open failed: Could
> not open device D:\MRE-DEV-
> SQL_data\MSSQL\Data\ENT_DATA.mdf for virtual device number
> (VDN) 0.
> What I could look at?
> Thanks a lot for the help.

Monday, February 13, 2012

Backup jobs hang :((

backup job hang

backup job hang

backup job hang

Friday, February 10, 2012

backup hang

sql backup files

Blog Archive

About Me