Ramblings of a DBA

Tara Kizer
posts - 165, comments - 832, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

April 2009 Blog Posts

Backup SQL Server Databases

EDIT: new version of stored procedure is located here.  Use the new version for 2005/2008.  Use the below version for 2000. I have modified isp_Backup, which is the stored procedure that I use to backup SQL Server databases.  In this version, I fixed two bug and added a feature.  Here are the changes: Fixed "2000 backupset" bug by qualifying the object to msdb.dbo.backupset Fixed the full backup check for SIMPLE recovery model databases (bug found by Eugene from PerfSpot.com) Added Red Gate SQL Backup functionality If you have scheduled jobs...

posted @ Tuesday, April 07, 2009 1:00 PM | Feedback (7) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET