Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Welcome to the Schneider Electric Global Website×
Goals and Symptoms
The user wants to have TMSCE databases backed up at a regular interval.
Causes and Fixes
Place the attached files in the C:\MSSQL2005\MSSQL.1\MSSQL\Backup location and create a Windows Scheduled Task to run the batch file (TMS Database Backup.bat) on a scheduled basis. Make sure a local admin account is used when scheduling the task.
Note: This batch file will back up the databases to the C:\MSSQL2005\MSSQL.1\MSSQL\Backup\ folder
(Removed File URL: 205154_15CA/TMS_Database_Backup.bat)(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/421aa5b59b7a4f0ec125787d0052859a/fl_block_5/0.F6?OpenElement&FieldElemFormat=gif)(Removed File URL: 205154_15CA/TMS_Database_Backup.sql)(Removed Image URL: /PubResEXPORT.nsf/2b87ee90be777fc085257c28006ee4ef/421aa5b59b7a4f0ec125787d0052859a/fl_block_5/0.90E?OpenElement&FieldElemFormat=gif)