PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 9/5/2011 5:33 PM by  Dennis Odri
Manually re-indexing and updating stats on SQL Express.
 0 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Dennis Odri
HelpMaster tech support
Helpdesk leader
Helpdesk leader
Posts:45
Points:81


--
9/5/2011 5:33 PM

    The SQL Server 2008 R2 Express edition that comes with HelpMaster doesn't have the capabitilty to perform maintenance tasks such as automated Database backups, re-indexing, and updating statistics to keep your database lean and performing well. There are however built-in Stored Procedures and functions that can be run manually on a regular basis to perform these tasks. Run each of the following SQL sections in order from SQL Server Management Studio Express, if installed. Alternately you can run it from the HelpMaster Database and Reports Wizard using Database Tools under the Execute SQL tab but can exclude the 'USE MyDatabase' statement from each section as your databse has already been selected in a previous step. Hope this helps those using SQL Server Express editions with Helpmaster. Don't forget to replace 'MyDatabase' with the name of your own HelpMaster database.

    -- This part checks database integrity including indexes --
    USE
    MyDatabase
    DBCC CHECKDB(N'MyDatabase'WITH NO_INFOMSGS

    -- This part rebuilds the database indexes --
    USE MyDatabase
    EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"

    -- This part backs up your database to the specified location with the specified backup name --
    BACKUP DATABASE MyDatabase
    TO  DISK = N'C:\HelpMaster DB Backups\Weekly Backups\MyDatabase_backup_2011_09_06.bak'
    WITH NOFORMAT, NOINIT,  NAME = N'MyDatabase_backup_2011_09_06',
    SKIP, REWIND, NOUNLOAD,  STATS = 10

    -- This part updates database statistics --
    USE MyDatabase
    EXEC
    sp_updatestats

    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...