Backup/Restore Status

Very often I have to do large backup and restores. This is either done via jobs, or the SQL Maintance tools. Neither so any status of a backup/restore. Overall progress, bytes written, etc. EM when backing up or restoring does show a GUI progress bar that isn't perfect, but does show progress to some extent.
So far I can look in the sysprocesses tables and find what spid is running the command, but that doesn't tell me much. The console command line util is for tape backups. Is there anything that can monitor the progress of backups and restores.
Thanks,
ETThe native SQL Server BACKUP and RESTORE commands have a STATUS parameter,
that when specified, returns status messages, indicating the progress of the
backup/restore operation.
Here's an example:
RESTORE DATABASE YourDB FROM DISK='\\SomePath\SomeFile.BAK' WITH STATUS = 1
See, SQL Server Books Online for more information.
Note that, even after specifying the STATUS with BACKUP or RESTORE command,
you will not see any progress messages coming up, while SQL Server is
creating the file.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Twiggy" <etwilegar@.nospamttgonline.com> wrote in message
news:D4500856-A29C-44EF-A7E8-828D7F6DDBCD@.microsoft.com...
Very often I have to do large backup and restores. This is either done via
jobs, or the SQL Maintance tools. Neither so any status of a backup/restore.
Overall progress, bytes written, etc. EM when backing up or restoring does
show a GUI progress bar that isn't perfect, but does show progress to some
extent.
So far I can look in the sysprocesses tables and find what spid is running
the command, but that doesn't tell me much. The console command line util is
for tape backups. Is there anything that can monitor the progress of
backups and restores.
Thanks,
ET|||Well I knew that EM was doing this and grabbing the results. In this case I'm not in control of the actual restore command. The command is already running, is there a way for another connection to get status on the operation. Is there a system table that information is written to?|||No Twiggy, there is not...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Twiggy" <etwilegar@.ttgonline.com> wrote in message
news:72E2D27A-36B1-4013-94D8-04A60F0A8782@.microsoft.com...
> Well I knew that EM was doing this and grabbing the results. In this case
I'm not in control of the actual restore command. The command is already
running, is there a way for another connection to get status on the
operation. Is there a system table that information is written to?
>|||I find this really weird. I wonder how the heck their internal developers debug backup/restore issues. I guess the code for backup and restoring hasn't changed a lot since 7, but still I'm sure there is a switch that would turn on logging of some sort. I'd hate to be the guy that had to write the Enterprise manager code, parsing the text output from restore with status.
Guess I'll wait for mirroring.