I noticed a pinned thread on the Time Matters forum regarding SQL Express backup. Here's an extremely simple yet effective process I suggest to clients using SQL Express. 

All flavors of SQL Server, including SQL Express, ship with a utility program that will execute SQL script from the Windows command line. This allows sites running SQL Express a very simple, cost-free opportunity to perform automated backups.

sqlcmd -S .\sqlexpress -Q "exec timematters9.tm9user.tm_backup timematters9, 'auto'" -o sqlbackuplog.txt

This command can be executed in an automated task. The result will be the same as running the backup from inside Time Matters. If you have not modified your TM backup procedure, a backup will be created in the default SQL Server backup folder with the name of the current day of the week.

WHERE
.\sqlexpress = the name of the Sql Server Instance
timematters9 = name of desired database to be backed up
tm9user = name of the time matters database owner

Just add this command to the Windows scheduler and you will have a simple to implement, centrally managed automation system for performing backups and any other SQL server maintenance you would like to perform at a regular interval.

• < Prev
• Next >