Backup duration

How would I find how long my full backup is taking since I started doing
backup, Is there system table in SQL 2005 or SQL 2000 that will show that
Thanks,Sure. Check out the backup history tables in msdb:
select * from msdb.dbo.backupset
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<msnews.microsoft.com> wrote in message news:%23riFs7zGIHA.4476@.TK2MSFTNGP06.phx.gbl...
> How would I find how long my full backup is taking since I started doing
> backup, Is there system table in SQL 2005 or SQL 2000 that will show that
>
> Thanks,
>|||Check out:
http://msdn2.microsoft.com/en-us/library/ms177648.aspx
It's for SQL 2005 only.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<msnews.microsoft.com> wrote in message
news:%23riFs7zGIHA.4476@.TK2MSFTNGP06.phx.gbl...
How would I find how long my full backup is taking since I started doing
backup, Is there system table in SQL 2005 or SQL 2000 that will show that
Thanks,