Technical FAQs

Ask a Question

How to back up Tenant Metering Software Commercial Edition (TMSCE) databases on a scheduled basis

Release Notice

TMSCE v2.5

Goals and Symptoms

Summary
The user wants to have TMSCE databases backed up at a regular interval.

Causes and Fixes

Procedure

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

Attachments

(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)


Legacy KB System (APS) Data: RESL205154 V1.0, Originally authored by MaTh on 04/25/2011, Last Edited by MaTh on 04/25/2011
Related ranges: Tenant Metering Software
Was this helpful?
What can we do to improve the information ?