Met/Track v8 db Backup

[bAdbOb]

Since we moved from Met/Track v7.3 to v8, I have been unable to write a script to do scheduled backups of the database. I used the script On Time Support posted for v7.3, but it does not work with v8. Does anyone have any ideas on how to do scheduled database backups? Thank you for your help!!!

[CalLabSolutions]

What is the Database back end you are using?

If you are using MET/TEAM and SQL Express this will work
sqlcmd -E -S .\SQLEXPRESS -d master -Q "BACKUP DATABASE 'mysqldatabase' TO DISK = N'D:\Backup\Databases' WITH INIT , NOUNLOAD , NAME = N'mysqldatabase backup', NOSKIP , STATS = 10, NOFORMAT"

If you have the Full version of SQL Server you are better off creating the back using the Agent.  There are a lot more features available for back up and database clean up.

Mike

[bAdbOb]

We are using SQL Express. Thank you very much for your help!!!

[CalLabSolutions]

You are welcome.
I recommend that you put on your road map and upgrade from SQL Express to the Full Version of SQL Server.  There are some powerful things the full version does.

I have been running SQL Server for more that 10 years now and I love the product.  I am able to back up by SQL Database to the Cloud for my offsite backups.  I think it is much safer than a local back up, but I don't think it can be done with SQL Express.

Mike

[dlynde]

I know this is an old topic on how to backup the MET/TRACK database.  We use a totally different method and I will write an app note and post in on the On Time Support web site some time this week.  Its a much better method with a rolling backup.  I had forgotten about the post on our website.  Sorry about that.  Doug Lynde