Meditech DR Support
TSG is dedicated to preserving the health and value of your Meditech Data Repository (DR) investment. We support all Magic systems, client server applications, and system components, as well as Microsoft Windows Server and SQL Server components. With deep knowledge of the Meditech architecture and the Microsoft platforms on which the DR resides, our experience staff can assist with DR implementations, update testing, table auditing, and ongoing maintenance and support.
SQL Database Administration Services for the Meditech Data Repository
TSG offers SQL Database Administration services to sites that are otherwise unable to secure a Database Administrator. Leverage the collective knowledge, skills, and experience of our team of professionals in all aspects of SQL Server and Meditech to improve your SQL Server performance and data integrity.
Advantages of using our services:
- Say goodbye to database worries. Leave the databases to us so you can get back to business.
- Our support professionals come from many different backgrounds and possess a wide range of expertise. This knowledge includes all aspects of Microsoft SQL Server and Meditech.
- No need to hire, train, and re-train your own internal staff.
- For a data repository to truly be successful, attention must be paid to the health of the server, database, and data. TSG’s Database Administration service can take care of all aspects of healthy SQL server performance and healthier data, helping to ensure success with your DR.
SQL Database Administration Implementation Services
The following services will be provided during your Meditech Data Repository configuration:
1. Installing and upgrading an SQL Server
The Database Administrator (DBA) is responsible for installing SQL Server or upgrading an existing SQL Server. In the case of upgrading the SQL Server, the DBA is responsible for making sure that if the upgrade is not successful, the SQL Server can be rolled back to an earlier release until the upgrade issues can be resolved.
2. Monitoring the database server’s health and tuning it accordingly
Monitoring the health of the database server means making sure that the following is done:
- The server is running with optimal performance
- The server is properly configured with the correct amount of memory and the proper configuration parameters
- The error log or event log is monitored for database errors
- Databases have routine maintenance performed on them and the overall system has periodic maintenance performed by the system administrator
3. Using storage properly
Maintaining the proper use of storage means making sure that databases and transaction logs are created correctly, monitoring space requirements, and adding new storage space when required
4. Backing up and recovering data
Backup and recovery are the DBA’s most critical tasks and include the following:
- Establishing standards and schedules for database backups
- Developing recovery procedures for each database
- Making sure that the backup schedules meet the recovery requirements
5. Managing database users and security
The DBA is responsible for setting up user’s database server login IDs and determining the proper security level for each user. Within each database, the DBA is responsible for assigning permissions to the various database objects such as tables, views, and stored procedures