SQL Express Maintenance - SQL Agent Alternatives, Scripts, etc.

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)

EXEC sp_who2

Terminate ones you don't want anymore:


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,

Related Scribbles:
  • SQL Server
  • Backup Tricks and Links

  • ID: 913
    Date Updated:
    2019-05-29 10:56:22
    Date Created:
    2008-08-22 14:03:03


     >> Leonard Chan's Homepage  >> Scribble Web  >> SQL Express Maintenance - SQL Agent Alternatives, Scripts, etc.
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.