Menu
I'd like to clarify what the optimal maintenance plan set up is for the ASPState database that is used by ASP.Net SQL Server session state.
The standard user database maintenance plan doesn't seem suitable. I'll never need to do a point-in-time restore of session data so it seems pointless to back up the database and transaction log files. However I still need to truncate the transaction log, run integrity checks and update statistics.
There must be existing guidance out there somewhere but my google-fu is failing me right now.
326
In Object Explorer, click the plus sign to expand the server where you want to create a maintenance plan. Click the plus sign to expand the Management folder. Right-click the Maintenance Plans folder and select Maintenance Plan Wizard. Follow the steps of the wizard to create a maintenance plan.
Create a Maintenance Plan for Full Backup To create a database maintenance plan, open SQL Server Management Studio (SSMS) and connect to the SQL Server instance. Once connected to the instance, expand Management Right-click on the Maintenance Plans Select New Maintenance Plan.
Make sure the database recovery model is 'Simple' Create a maintenance plan with these options: - Check database integrity - Reorganize index - Clean up history
Schedule this once a week and you should be fine.
94
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
