SQL 2008 Workgroup Scheduled Backup

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Our company recently purchased Goldmine to replace our current CRM software
and it came with SQL 2008 Workgoup Edition. I cannot execute a maintenance
plan in this version because it does not come with SQL Integration
Services.so I'm trying to setup a scheduled job in SQL Server Agent. I've
created plans before using the maintenance plan wizard in 2005 enterprise
but never had to create one manually. I've found this page (
https://help.maximumasp.com/KB/a611/creating-manual-maintenance-plans-sql-server-2008-web.aspx)
that has instructions on what code to use to create a manual maintenance
plan but I'm not sure on the order. The order they are in now is:

1. Full Backup
2. Execute SQL Server Job Agent
3. Check Database Integrity
4. Shrink Database
5. Reorganize Indexes
6. Rebuild Indexes
7. Update Statistics
8. History Cleanup
9. Maintenance Cleanup
10. Notify Operator Task

What order should they be in to run properly?
Should # 2 be in there at all? Wouldn't the job have already executed
therefore not needing a command to execute?


Thanks
Andrew


.

Relevant Pages

  • Re: ADO.NET query execution much slower than SQL Management Studio
    ... A stored procedure uses a query plan that's created when the SP is first executed and reuses that plan regardless of the suitability of the plan from that point forward--until it's replaced. ... Something that would affect the .NET SqlClient but not SQL Mgmt Studio? ... takes less than one second to execute. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: 5 Day Backup Maintenance Plan Help?
    ... Pre SP2 you have to Modify the maintenance plan to add the Maintenance ... Backup file for every database" ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Poor execution plan with variables vs. constants
    ... >> SQL server selects not quite good plan as if I use constants. ... > Local variables can not always be used to hel; optimize SQL statements. ... "execute" it is not quite good solution, ...
    (microsoft.public.sqlserver.programming)
  • Re: tkprof explain=user/password password exposed?
    ... the sql will execute. ... The trace file lines already contain the actual plan that oracle ...
    (comp.databases.oracle.server)
  • Re: Chkdsk Failing to Start
    ... Enquire, plan and execute ... You can access Event Viewer by selecting Start, ...
    (microsoft.public.windowsxp.general)