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?


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,
 

Related Scribbles:
  • Backup Tricks and Links
  • SQL Server


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

    Edit

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