Capture Backup output to table? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Capture Backup output to table?

Author

Topic

abarringer
Starting Member

13 Posts

Posted - 2005-02-11 : 09:36:06

Is there anyway to capture the backup db output to a table?

insert into mytable
Backup database to device

of course doesn't work... because of the transaction.

Thank you for any pointers.

Kristen
Test

22859 Posts

Posted - 2005-02-13 : 07:15:30

Somthing like this?


SELECT TOP 10 BS.backup_finish_date, BMF.physical_device_name, *
FROM	msdb.dbo.backupmediafamily BMF
	JOIN msdb.dbo.backupmediaset BMS
		ON BMF.media_set_id = BMS.media_set_id
	JOIN msdb.dbo.backupset BS
		ON BS.media_set_id = BMS.media_set_id
WHERE	    BS.database_name = 'MyDatabaseName'
	AND BS.backup_finish_date BETWEEN '01-Feb-2005 ' AND '14-Feb-2004'
ORDER BY BS.backup_finish_date DESC

Kristen

abarringer
Starting Member

13 Posts

Posted - 2005-02-15 : 16:07:30

Yes, exactly.

Trying to get MB per second throughput for the backup. This gives me all the info I need.

Thanks,
Andrew

Kristen
Test

22859 Posts

Posted - 2005-02-16 : 14:39:32

"My server's faster than yours. And its got wider wheels. And a bigger turbo charger"

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources