Database maintenance routines
Very cool list of SQL Server Maintenance SP's...
"isp_DBCC_CHECKDB - perform integrity checks on all databases
isp_DBCC_INDEXDEFRAG - perform index defragmentation
isp_DBCC_DBREINDEX - rebuild the indexes
isp_Backup - full backup
isp_Backup_LS - full backup using SQL LiteSpeed
isp_Backup_TLog - transaction log backup
isp_DeleteBackupHistory - delete backup history from msdb backup system tables"
All with T-SQL source (of course the source is available... right? For now, yes, but when SQL2005 hits and all the assemblies start hitting the net, the source might not always be available. But I for one will try to not use a SQL assembly unless I can review the source... to scary not to...)
Tara's like an uber-SQL DBA... and codes up some great T-SQL...
No comments:
Post a Comment
NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...
ALL comments are moderated. I will review every comment before it will appear on the blog.
Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...
I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...
Please see my comment policy for more information if you are interested.
Thanks,
Greg
PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...