How To
- Approve order function.
- Cost Activities
- How does the “Approved Supplier” (QA status) functions work?
- How does the Approve direct purchases onshore work?
- How does the rule-based approval matrix work?
- How To - Set Failure Report Running Number
- How To - Add SQL Server to Windows Firewall Exception
- How To - Access the report template editor
- How To - Accounts and Budget (v. 2.662 and later)
- How To - Active a unit for use with the Incidents Module
- How To - Add same document on multiple components
- How To - Approve Purchase Orders and Change Requests when using Approval Rules and Change Approval
- How To - Assign user rights
- How To - Automatically resize images
- How To - Backup TMv2
- How To - Cancel Job History (Job Signed Out In Error)
- How To - Cancel job history (Video Link)
- How To - Catalogs
- How To - Change a Unit Code in TM Master V2
- How To - Check for File Not Found Error. Document Handling.
- How To - Circulating Components
- How To - Company tags
- How To - Connect the TM Master v2 Client Application
- How To - Connect the TM Master v2 client to more than one database
- How To - Contract Management
- How To - Copy Components, Component Jobs and Spare Parts
- How To - Create a new unit
- How To - Create a New User TM Master v2
- How To - Create and use batch jobs in TM
- How To - Create Credit Note
How To - Take Database Backup on Network Drive
Please find the step by step guide to take the TM Master database backup on the network drive.
Step 1: To make a network share visible to sql server it should be mapped as a network drive.
Step 2: To identify that network drive in sql server you will use the ‘xp_cmdshell’ command. Before that you need to make sure that the ‘xp_cmdshell’ command is configured and enabled in your sql instance as per below.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'xp_cmdshell' ,1
GO
RECONFIGURE
GO
Step 3: Define the share drive for sql with ‘XP_CMDSHELL’ command in sql server.
EXEC XP_CMDSHELL 'net use Z: \\192.168.43.238\tmbackup [password] /USER:[user name]'
EXEC XP_CMDSHELL 'net use Z: \\192.168.43.238\tmbackup'
Steps 4: To verify the new drive, you can use the below command that will show you all files in that newly mapped drive.
EXEC XP_CMDSHELL 'net use Z:'
Steps 5: Select the mapped network drive path to store the backup file.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article