|
It-Share > Sql > Sql Services
|
|
|
|
| Overview |
|
We provide Microsoft SQL Servers Administration as service remote or on site for solutions built on simple or complex architectures:
• Log shipping; • MSSQL active/passive or active/active Clusters; • Mirroring; • Replications between MSSQL servers; • Transfers of data between MSSQL servers and other database systems.
|
|
| MSSQL Administration as service |
|
|
The MSSQL Administration as service contains a set of operations that can be made daily, weekly or monthly having main objectives:
• As much as possible 100% high availability of MSSQL Servers through databases maintenance, logs checking and discovering in time the bottle necks;
• The assurance of safety data storage in databases through backup plans and verifications of their running;
• The security of accessing data by the users through a good politics of rights and roles;
• The assurance of data transfers between database servers through replication monitor or other third party mechanisms.
|
|
| Microsoft SQL Server Administration |
|
We perform the following operations for Microsoft SQL Servers administration:
•Monitor of the job and existent replications; • Management of the users; • Monitor of the SQL logs and of SO; • Plans stopping MSSQL Server Services; • Backup databases; • Restore databases; • Testing databases backups; • Migrations of MSSQL Servers; • Maintaining 'up to date' systems database versions of MSSQL Server; • Other database maintenance operations (rebuild index , shrink, etc.); • Performance Monitor of servers based on performance counters for identifying the bottle-necks; • Support for administrators or partners of the applications (updates); • Admeasurements and previsions of hard disks spaces.
|
|
| |
|
|
|
|
|
|
|