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
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
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)