SQL Server Express 2005 and automatic index reorganisation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Markus - 17 Jun 2009 07:41 GMT

Hello,

I've installed SQL Server Express 2005 for one application and found
out now that one needs to update indexes from time to time. Other
databases do this automatically. How can I achieve this with the SQL
Server Express? What do I need and how to do it? I'm running it on
Windows XP Prof. SP3. Letting run the reorganisation on PC startup or
as sheduled task would be ok for me.

Any hints?

Greetings

Markus

Reply to this Message

Andrea Montanari - 17 Jun 2009 17:04 GMT

hi Markus,

> Hello,
>
[quoted text clipped - 4 lines]
> Windows XP Prof. SP3. Letting run the reorganisation on PC startup or
> as sheduled task would be ok for me.

SQLExpress does not provide the SQL Server Agent, thus you can not schedule
a "native" maintenace/backup or whatever task via a SQL Server Agent job..

you have to rely on the native OS scheduler, writing your own command file
including the actual BACKUP DATABASE... statement to be executed, or on
other solutions even based on the OS scheduler, like
http://www.sqldbatips.com/showarticle.asp?ID=27 and
http://www.sqldbatips.com/showarticle.asp?ID=29, third party solutions like
http://www.lazycoding.com/products.aspx or
http://www.valesoftware.com/products-express-agent.php,
http://www.codeproject.com/vb/net/SQLAgent.asp, or custom solutions based on
the Service Broker as indicated in
http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx

regards

Signature

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de
--------- remove DMO to reply

Reply to this Message