Welcome to weblogs.com.pk Sign in | Join | Help

SQL Server: Database Maintenance Routine

From Tara Duggan’s weblog

http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Over the past couple of weeks, I have posted various database maintenance stored procedures.  Here's a listing of them:

·         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

Do not put these in the master database.  An Admin database should be created where non-application specific objects are put.  All of the stored procedures are designed so that they do not need to be in any particular database.

Use them at your own risk.  If you don't use them, at the very least create your own.  Don't use the maintenance plan wizards or the sqlmaint utility!

 

Published Thursday, July 29, 2004 9:31 PM by khurram
Filed under:

Comments

# tax professional software

Friday, November 05, 2004 2:04 AM by tax professio
<h1>You can also check the sites about<A HREF="http://www.california-loan-mortgage-advisor.info/"> california loan mortgage </A> | california loan mortgage | <A HREF="http://www.california-loan-mortgage-advisor.info/">http://www.california-loan-mortgage-advisor.info/</A> | <br/><A HREF="http://www.mortgage-california-home-loan-ebanking.info/"> mortgage california home loan </A> | mortgage california home loan | <A HREF="http://www.mortgage-california-home-loan-ebanking.info/">http://www.mortgage-california-home-loan-ebanking.info/</A> | <br/><A HREF="http://www.honda-finance-consultant.info/"> honda finance </A> | honda finance | <A HREF="http://www.honda-finance-consultant.info/">http://www.honda-finance-consultant.info/</A> | <br/><A HREF="http://www.card-credit-uk-e-site.info/"> card credit uk </A> | card credit uk | <A HREF="http://www.card-credit-uk-e-site.info/">http://www.card-credit-uk-e-site.info/</A> | <br/><A HREF="http://www.calculator-loan-payment-e-bank.info/"> calculator loan payment </A> | calculator loan payment | <A HREF="http://www.calculator-loan-payment-e-bank.info/">http://www.calculator-loan-payment-e-bank.info/</A> | <br/><A HREF="http://www.cheap-flowers-leading-site.info/"> cheap flowers </A> | cheap flowers | <A HREF="http://www.cheap-flowers-leading-site.info/">http://www.cheap-flowers-leading-site.info/</A> | <br/><A HREF="http://www.california-mortgage-second-advisor.info/"> california mortgage second </A> | california mortgage second | <A HREF="http://www.california-mortgage-second-advisor.info/">http://www.california-mortgage-second-advisor.info/</A> | <br/><A HREF="http://www.beer-cellar.info/"> beer </A> | beer | <A HREF="http://www.beer-cellar.info/">http://www.beer-cellar.info/</A> | <br/><A HREF="http://www.federal-student-loans-consultant.info/"> federal student loans </A> | federal student loans | <A HREF="http://www.federal-student-loans-consultant.info/">http://www.federal-student-loans-consultant.info/</A> | <br/><A HREF="http://www.auto-financing-calculator-advisor.info/"> auto financing calculator </A> | auto financing calculator | <A HREF="http://www.auto-financing-calculator-advisor.info/">http://www.auto-financing-calculator-advisor.info/</A> | <br/>... </h1>

# d&#101;bt c&#111;ll&#101;ct&#105;&#111;n

Friday, November 05, 2004 2:08 AM by d&#101;bt
<h1>You are invited to check some relevant pages about<A HREF="http://www.construction-loan-4u.info/"> c&#111;nstr&#117;ct&#105;&#111;n l&#111;&#97;n </A> | c&#111;nstr&#117;ct&#105;&#111;n l&#111;&#97;n | <A HREF="http://www.construction-loan-4u.info/">http://www.construction-loan-4u.info/</A> | <br/><A HREF="http://www.credit-employee-state-union-e-site.info/"> cr&#101;d&#105;t &#101;mpl&#111;y&#101;&#101; st&#97;t&#101; &#117;n&#105;&#111;n </A> | cr&#101;d&#105;t &#101;mpl&#111;y&#101;&#101; st&#97;t&#101; &#117;n&#105;&#111;n | <A HREF="http://www.credit-employee-state-union-e-site.info/">http://www.credit-employee-state-union-e-site.info/</A> | <br/><A HREF="http://www.financing-rv-e-site.info/"> f&#105;n&#97;nc&#105;ng rv </A> | f&#105;n&#97;nc&#105;ng rv | <A HREF="http://www.financing-rv-e-site.info/">http://www.financing-rv-e-site.info/</A> | <br/><A HREF="http://www.wristwatch-deals.info/"> wr&#105;stw&#97;tch </A> | wr&#105;stw&#97;tch | <A HREF="http://www.wristwatch-deals.info/">http://www.wristwatch-deals.info/</A> | <br/><A HREF="http://www.national-city-mortgage-ebanking.info/"> n&#97;t&#105;&#111;n&#97;l c&#105;ty m&#111;rtg&#97;g&#101; </A> | n&#97;t&#105;&#111;n&#97;l c&#105;ty m&#111;rtg&#97;g&#101; | <A HREF="http://www.national-city-mortgage-ebanking.info/">http://www.national-city-mortgage-ebanking.info/</A> | <br/><A HREF="http://www.interest-only-loans-consultant.info/"> &#105;nt&#101;r&#101;st &#111;nly l&#111;&#97;ns </A> | &#105;nt&#101;r&#101;st &#111;nly l&#111;&#97;ns | <A HREF="http://www.interest-only-loans-consultant.info/">http://www.interest-only-loans-consultant.info/</A> | <br/><A HREF="http://www.send-flower-leading-site.info/"> s&#101;nd fl&#111;w&#101;rs </A> | s&#101;nd fl&#111;w&#101;rs | <A HREF="http://www.send-flower-leading-site.info/">http://www.send-flower-leading-site.info/</A> | <br/><A HREF="http://www.2004-tax-software-advisor.info/"> 2004 t&#97;x s&#111;ftw&#97;r&#101; </A> | 2004 t&#97;x s&#111;ftw&#97;r&#101; | <A HREF="http://www.2004-tax-software-advisor.info/">http://www.2004-tax-software-advisor.info/</A> | <br/><A HREF="http://www.card-gold-platinum-4u.info/"> c&#97;rd ch&#97;s&#101; v&#105;s&#97; </A> | c&#97;rd ch&#97;s&#101; v&#105;s&#97; | <A HREF="http://www.card-gold-platinum-4u.info/">http://www.card-gold-platinum-4u.info/</A> | <br/>... </h1>
New Comments to this post are disabled