Some free programs that copy the MS SQL Agent. One of these is going to be handy for scheduling backups and optimizes for SQL Express databases... but which one?
http://www.codeproject.com/KB/database/SQLAgent.aspx
http://www.lazycoding.com/products.aspx
And this highly rated script: http://ola.hallengren.com/sql-server-backup.html
Microsoft published this list of stored procedures and scripts to help backup, optimize, and other things for SQL Express.
http://archive.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ExpressMaintenance
---
List all the processes on the SQL Server (i.e. look for stuck ones)
EXEC sp_who2
Terminate ones you don't want anymore:
KILL
List what has what locked
exec sp_lock
List more detail on SPID
exec sp_who SPID
---
SQL Express with Advanced Services (including Full Text Search):
In recent 2016 and newer, this is hidden behind a Visual Studio login.
tags: msde, sqlexpress, backup,