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?
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.
List all the processes on the SQL Server (i.e. look for stuck ones)
Terminate ones you don't want anymore:
List what has what locked
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,