Maintenance for SQL 2005 Express:

Maintenance for SQL 2005 Express:How to create a maintenance schedule for 2005 express. In SQL2000 there was Maintenance for creating schedules where did it get moved to in SQL 2.005 express?

since SSIS(SQLServer Integration Service) is not there in the Express, you can not create maintenance plan in SQL Serer Express. You can make your own script and call that using windows scheduler.

You have lot of limitation in Express. If you want more feature you may go for licensed versions

Madhu

|||

SQL Server Agent is NOT included with SQL Express.

You can use a combination of Stored Procedures, SQLCmd.exe, and the Windows Scheduler to create and run your maintenance routines.

And here are some open source projects and guidelines that seem to provide much of the SQL Agent service to SQL Express.

SQL Server 2005 Agent Equilevent for SQL Server 2005 Express
http://www.codeproject.com/vb/net/SQLAgent.asp
http://www.lazycoding.com/products.aspx
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.sqldbatips.com/showarticle.asp?ID=29

|||

Arnie,

Thanks for your reply it was very helpful.

Harry Gibson