Re: Feedback from Tape Backups

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 13:58:49 +0100

In this case, the client application is SQL Server Agent, more specific, the sub-component in Agent
that executes your TSQL job steps. And Agent isn't written to output this information "as it goes".
It might update the output file as information comes in (I haven't tested this), so I think that
this is probably your best bet. Another option is of course to schedule an EXE file that you wrote
and you have in your EXE file code to output the information to where ever you want it to go. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Hunter" <ms-nntp-nospam@jshunter.co.uk> wrote in message 
news:eL976GjHFHA.1860@TK2MSFTNGP15.phx.gbl...
> Hi Folks,
>
> I'm trying to find a way to get access to the STATS output from the BACKUP
> command during automated backups.
>
> When running the BACKUP command in QA it shows the output, line by line, as
> the backup progresses.  Is there any way I can get this information when the
> BACKUP statement is run from a job?  I thought the console tool might have
> been the answer, but it doesn't show any progress messages.
>
> Is the only option to use the Job/Step/Adv/Output to file option, and "tail"
> the file?
>
> TIA
>
> J.
>
>
>

Relevant Pages

  • Re: Feedback from Tape Backups
    ... With regard to your comments on creating my own EXE, ... > In this case, the client application is SQL Server Agent, more specific, ... > and you have in your EXE file code to output the information to where ever ... >> the backup progresses. ...
    (microsoft.public.sqlserver.tools)
  • Re: Lizensierungsmodelle bei SPS
    ... Veritas bietet für den SPS2001 einen Agent an. ... natürlich auch den separat erhältlichen SQL Server ... Hier ist schon 'mal ein netter Artikel zu Backup & Restore ...
    (microsoft.public.de.german.sharepointportalserver)
  • Re: Trojans Galore
    ... >BA MCP MCSE ... Mailwasher that the Blacklist and the filter list were blank and 'should we ... Well I had done nothing to deserve that and the backup were not even up to date. ... How do I get permission to use Agent ...
    (microsoft.public.win2000.general)
  • Re: NT Backup does not detect my tape device
    ... The folder in question is on the D drive of that server and the ... The backup device works fine except when trying to connect this DB ... Not the open file agent. ... Certainly my tape device is a bit out ...
    (microsoft.public.windows.server.sbs)
  • Re: Automatic import not working
    ... Make a backup and start over on a copy. ... breakpoint in before the start of the loop. ... > Calls", strpath & strfile1, False ... > 'imports agent file to Agent Data table ...
    (microsoft.public.access.modulesdaovba)
Quantcast