|
 |
Cygnet-Disaster Recovery |
|
|
|
|
Installation, Management, Backups & Restores
|
|
 |
Our Services! |
|
|
|
 |
Installing & configuring SQL Server 2005
|
 |
Database Backups & Restores |
 |
Security Management |
 |
SQL Server monitoring and Data transfers to & fro
Automate administrative tasks
|
 |
Data Replications between SQL Server instances |
 |
High availability maintenance |
|
|
| Installing & Configuring SQL Server 2005 |
Managin Databases & Files |
 |
Preparing & Installing SQL Server 2005 |
 |
Managing a SQL Server 2005 Installation |
 |
Installing and Configuring SQL Server 2005 |
|
 |
Planning, Creating Databases |
 |
Managing Databases |
 |
Monitoring and Managing File group Usage |
 |
Viewing Database Metadata |
|
| Disaster Recovery |
Managing Security |
 |
Planning & Implementing a Backup Strategy |
 |
Backing & Restoring User Databases |
 |
Performing Online Restore Operations |
 |
Recovering Data from Database Snapshots |
 |
System Database and Disaster Recovery |
 |
Performing Piecemeal Backup and Restore Operations |
|
 |
Overview of SQL Server Security |
 |
Protecting the Server Scope |
 |
Protecting the Database Scope |
 |
Managing Keys and Certificates in SQL Server |
 |
Creating Logins and Assigning Server-Scope Permissions |
 |
Creating and Managing Users |
 |
Using a Certificate to Protect Data |
 |
Describe how SQL Server manages security |
 |
Protect SQL Server at the server level |
 |
Protect SQL Server databases |
 |
Use keys and certificates to protect SQL Server objects |
|
| Monitoring SQL Server |
Transferring Data |
 |
Monitoring Current Activity , SQL Performance |
 |
Using SQL Server Profiler to trace activities |
 |
Using Event Notifications |
 |
Tracing SQL Server Activity |
 |
Examine the current activity in a SQL Server instance |
 |
Use event notifications to capture and monitor significant events for a SQL Server instance |
|
 |
Overview of Data Transfer |
 |
Using SQL Server Integration Services |
 |
Creating, Deploying an SSIS Package |
 |
Extracting Data, Performing Lookups, Sorting, and Splitting Data using SSIS |
 |
Using SQL Server Integration Services to transfer data into a SQL Server database |
|
| Automating Administrative Tasks |
Implementing Replication |
 |
Automating Administrative Tasks in SQL Server 2005 |
 |
Configuring the SQL Server Agent |
 |
Creating Jobs and Operators |
 |
Creating Alerts |
 |
Manage Multiple Servers |
 |
Manage & Configure SQL Server Agent Security |
 |
Define SQL Server 2005 administrative tasks and schedule these tasks to run automatically |
 |
Script tasks by using SQL Server jobs, and define operators for managing these jobs |
 |
Define alerts to warn operators about events raised by SQL Server |
 |
Define and manage administrative tasks that span multiple servers |
 |
Configure SQL Server Agent security |
|
 |
Configuring & Implementing Replication |
 |
Creating a Publication |
 |
Creating a Subscription |
 |
Implementing HTTP Merge Replication |
 |
Availability in a distributed environment |
|
| Maintaining High Availability |
 |
Implementation of High Availability |
 |
Implementing Server Clustering |
 |
Implementing Database Mirroring |
 |
Implementing Log Shipping |
 |
Implementing Peer-to-Peer Replication |
 |
Configuring Database Mirroring to Support Failover |
 |
Describe the factors affecting database availability |
 |
Explain how to implement clustering to support fast failover of computers running Microsoft SQL Server instances |
 |
Describe how to use SQL Server mirroring to implement a software solution for fast failover |
 |
Describe how to implement log shipping to support fast recovery of a standby SQL Server database |
 |
Explain how to use peer-to-peer replication to implement high |
|
|
|
Cygnet Infotech – Exceptional Service Provider
Cygnet Infotech is one of the few service providers that support both internal as well as external support.
Request Execution!
 |
The request execution life cycle comprises of just a few easy operations |
 |
Information such as products or services, solutions offered status of requests; etc is readily available at hand |
 |
Easy monitoring of ongoing requests, queues, status of requests, etc can be monitored easily |
At Cygnet Infotech, we make sure that no request goes unanswered, response is prompt, and no problem is left unresolved. The whole request submission process is Internet driven hence allows clients (internal or external) to access service histories.
|
|