Backup Script Completing But Not Working

I have a SQL Server Agent job that executes the script listed below (using a step of type "Analysis Services Command") to do a backup of an SSAS database on a nightly basis. The job takes a while (say 15 mins or so) and appears to be busily doing something (meaning the CPU's on the server have activity). However, after the script completes, there is no backup file anywhere to be found. Anyone have any idea what might be happening?

BTW, if I execute this command manually as an XMLA command while in a query window in SSMS, it seems to complete successfully (producing the .abf file) every time...

Dave Fackler

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>DatabaseXYZ</DatabaseID>
</Object>
<File>DatabaseXYZ.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>

There is a problem with SQL Agent not reporting propertly case of failed XMLA command.

It should have been fixed in SP2. Try installing CTP of SP2 and see if you are geting failure of SQL Agent Job.

Another suggestion. Make sure your SQL Agent job has server name defined correctly.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

I'll take a look at SP2. However, even if that resolves the issue of SQL Agent not reporting when an XMLA command fails, it doesn't really help with WHY the XMLA command would be failing in the first place. The server name is definitely defined correctly and the server seems to be doing something while the command executes. But no .abf file is generated. Is there some way I can troubleshoot this issue to determine why the XMLA command might be failing?

Dave F.

|||

Once you get a fix in SQL Agent you'll be able to get a useful error message telling you the nature of the problem. And that should help troubleshooting SQL Agent job.

For now you can try installing CTP of SP2.

Another idea for you is to use ascmd utility that allows you to execute XMLA commands. It has great functionality allows for having parametric XMLA command, where you can simply plug name of your DB and that would take care backing up your database. It also allows logging output of XMLA command's execution. Once you get it working, you can use SQL Agent to schedule backup using ascmd.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am running SQL 2005 with SP2 and have the same issue.

When I use a SQL Agent job with a Sql Server Analysis Services Command it does not report any error or failure in that command.

An example command is:

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>PGPDailySales</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>

If the cube definition or data has errors so this command fails, the Agent Job step still reports success.

How can this issue be reported to Microsoft so it may be fixed in the next version?

Backup Script Completing But Not Working

I have a SQL Server Agent job that executes the script listed below (using a step of type "Analysis Services Command") to do a backup of an SSAS database on a nightly basis. The job takes a while (say 15 mins or so) and appears to be busily doing something (meaning the CPU's on the server have activity). However, after the script completes, there is no backup file anywhere to be found. Anyone have any idea what might be happening?

BTW, if I execute this command manually as an XMLA command while in a query window in SSMS, it seems to complete successfully (producing the .abf file) every time...

Dave Fackler

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>DatabaseXYZ</DatabaseID>
</Object>
<File>DatabaseXYZ.abf</File>
<AllowOverwrite>true</AllowOverwrite>
</Backup>

There is a problem with SQL Agent not reporting propertly case of failed XMLA command.

It should have been fixed in SP2. Try installing CTP of SP2 and see if you are geting failure of SQL Agent Job.

Another suggestion. Make sure your SQL Agent job has server name defined correctly.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

I'll take a look at SP2. However, even if that resolves the issue of SQL Agent not reporting when an XMLA command fails, it doesn't really help with WHY the XMLA command would be failing in the first place. The server name is definitely defined correctly and the server seems to be doing something while the command executes. But no .abf file is generated. Is there some way I can troubleshoot this issue to determine why the XMLA command might be failing?

Dave F.

|||

Once you get a fix in SQL Agent you'll be able to get a useful error message telling you the nature of the problem. And that should help troubleshooting SQL Agent job.

For now you can try installing CTP of SP2.

Another idea for you is to use ascmd utility that allows you to execute XMLA commands. It has great functionality allows for having parametric XMLA command, where you can simply plug name of your DB and that would take care backing up your database. It also allows logging output of XMLA command's execution. Once you get it working, you can use SQL Agent to schedule backup using ascmd.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am running SQL 2005 with SP2 and have the same issue.

When I use a SQL Agent job with a Sql Server Analysis Services Command it does not report any error or failure in that command.

An example command is:

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>PGPDailySales</DatabaseID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>

If the cube definition or data has errors so this command fails, the Agent Job step still reports success.

How can this issue be reported to Microsoft so it may be fixed in the next version?

Backup on Network/Mapped drives Using Enterprise Manager

Dear all,
This is My Query step by step description:
1. I want to take backup of sql server databases on network drives(mapped
drives) Using Enterprise Manager tool only.
2. I am getting network drives list on some machines not on all machines
when I opened Backup Device location window in Enterprise Manager.
3. My SQL Server Services are also configured with domain administrator
account only.
Please let me know the way to get list of network drives when I am taking
backup using Enterprise Manager.(I know the way to work with SQL Query
Analyzer).
Thanks in Advance
Regards
Ravisrikrishna
You can't.
We've already explained this in your earlier post.
SQL EM only looks at physical drives.
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>
|||Hi
You need to specify UNC names and not use mapped drives.
John
"Lokesh Bhatnagar" wrote:

> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>
|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>

Backup on Network/Mapped drives Using Enterprise Manager

Dear all,
This is My Query step by step description:
1. I want to take backup of sql server databases on network drives(mapped
drives) Using Enterprise Manager tool only.
2. I am getting network drives list on some machines not on all machines
when I opened Backup Device location window in Enterprise Manager.
3. My SQL Server Services are also configured with domain administrator
account only.
Please let me know the way to get list of network drives when I am taking
backup using Enterprise Manager.(I know the way to work with SQL Query
Analyzer).
Thanks in Advance
Regards
RavisrikrishnaYou can't.
We've already explained this in your earlier post.
SQL EM only looks at physical drives.
--
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||Hi
You need to specify UNC names and not use mapped drives.
John
"Lokesh Bhatnagar" wrote:
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>

Backup on Network/Mapped drives Using Enterprise Manager

Dear all,
This is My Query step by step description:
1. I want to take backup of sql server databases on network drives(mapped
drives) Using Enterprise Manager tool only.
2. I am getting network drives list on some machines not on all machines
when I opened Backup Device location window in Enterprise Manager.
3. My SQL Server Services are also configured with domain administrator
account only.
Please let me know the way to get list of network drives when I am taking
backup using Enterprise Manager.(I know the way to work with SQL Query
Analyzer).
Thanks in Advance
Regards
RavisrikrishnaYou can't.
We've already explained this in your earlier post.
SQL EM only looks at physical drives.
Nik Marshall-Blank MCSD/MCDBA
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||Hi
You need to specify UNC names and not use mapped drives.
John
"Lokesh Bhatnagar" wrote:

> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lokesh Bhatnagar" <lokesh@.webdunia.com> wrote in message
news:%23jH3N$owFHA.3860@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> This is My Query step by step description:
> 1. I want to take backup of sql server databases on network drives(mapped
> drives) Using Enterprise Manager tool only.
> 2. I am getting network drives list on some machines not on all machines
> when I opened Backup Device location window in Enterprise Manager.
> 3. My SQL Server Services are also configured with domain administrator
> account only.
> Please let me know the way to get list of network drives when I am taking
> backup using Enterprise Manager.(I know the way to work with SQL Query
> Analyzer).
> Thanks in Advance
> Regards
> Ravisrikrishna
>
>

backup job step from remote server

I want to run a backup of a database against a remote server through a SQL
Agent job.
So I have the following TSQL Command in my job step. I know it works, but is
there something better ?
xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
''M:\backups\test.bak'' with init "'
You could just do an OS cmd step and skip the xp_cmdshell. Or a linked
server with the proper permissions. I am not sure if those are much better
though...
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:epMGCADRIHA.4684@.TK2MSFTNGP02.phx.gbl...
>I want to run a backup of a database against a remote server through a SQL
>Agent job.
> So I have the following TSQL Command in my job step. I know it works, but
> is there something better ?
> xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
> ''M:\backups\test.bak'' with init "'

backup job step from remote server

I want to run a backup of a database against a remote server through a SQL
Agent job.
So I have the following TSQL Command in my job step. I know it works, but is
there something better ?
xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
''M:\backups\test.bak'' with init "'You could just do an OS cmd step and skip the xp_cmdshell. Or a linked
server with the proper permissions. I am not sure if those are much better
though...
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:epMGCADRIHA.4684@.TK2MSFTNGP02.phx.gbl...
>I want to run a backup of a database against a remote server through a SQL
>Agent job.
> So I have the following TSQL Command in my job step. I know it works, but
> is there something better ?
> xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk =
> ''M:\backups\test.bak'' with init "'

backup job step from remote server

I want to run a backup of a database against a remote server through a SQL
Agent job.
So I have the following TSQL Command in my job step. I know it works, but is
there something better ?
xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk = ''M:\backups\test.bak'' with init "'You could just do an OS cmd step and skip the xp_cmdshell. Or a linked
server with the proper permissions. I am not sure if those are much better
though...
--
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:epMGCADRIHA.4684@.TK2MSFTNGP02.phx.gbl...
>I want to run a backup of a database against a remote server through a SQL
>Agent job.
> So I have the following TSQL Command in my job step. I know it works, but
> is there something better ?
> xp_cmdshell 'sqlcmd -S ServerA -Q "backup database test to disk => ''M:\backups\test.bak'' with init "'

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

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

Backup job Fails every time:

Dear Friends!
I have a scheduled job on my production server which always fails. When I
see the job history step details I can see 100 % backedup and along with
that I receive error
[SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
step failed.
Pl, guide me. Job fail isn't affordable on my production database.
I sincerly thank you!
S.Lakshminarayanan.
Message posted via http://www.sqlmonster.com
Can you try issuing a BACKUP DATABASE statement via T-SQL through Query
Analyzer? It would be helpful to see the errors (if there are any). Before
running the backup make sure that you have results set to text.
The syntax is easy enough:
BACKUP DATABASE SLNKMIL TO DISK = 'x:\SLNKMIL.bak' WITH INIT
Keith
"lakshminarayan iyer via SQLMonster.com" <forum@.SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@.SQLMonster.c om...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database
'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
> Pl, guide me. Job fail isn't affordable on my production database.
> I sincerly thank you!
> S.Lakshminarayanan.
> --
> Message posted via http://www.sqlmonster.com
|||Is the database in Simple recovery mode? If so you can not do a log backup.
Andrew J. Kelly SQL MVP
"lakshminarayan iyer via SQLMonster.com" <forum@.SQLMonster.com> wrote in
message news:67ccca76be724649be8629b2da37796a@.SQLMonster.c om...
> Dear Friends!
> I have a scheduled job on my production server which always fails. When I
> see the job history step details I can see 100 % backedup and along with
> that I receive error
> [SQLSTATE 01000] (Message 3211) Processed 1 pages for database 'SLNKMIL',
> file 'SLNKMIL_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP
> DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The
> step failed.
> Pl, guide me. Job fail isn't affordable on my production database.
> I sincerly thank you!
> S.Lakshminarayanan.
> --
> Message posted via http://www.sqlmonster.com