PT 2520 Database Concepts
Unit 9 Research Assignment 1
The list of information concerning the threats and recovery and securing are all from the Microsoft address in the works cited.
1. Look up some best practices for Disaster recovery.
Create a backup and restore plan
-Be sure your backup plan specifies:
-The computer where backups will be stored
-The programs that you will use to back up your system
-The computers you want to back up
-The schedule when backups will occur
-The offsite location where you will archive backups
Keep a written record of all changes to your BizTalk Server system
BizTalk is an industry initiative headed by Microsoft to promote Extensible Markup Language (XML) as the common data exchange language for e-commerce and application integration on the Internet
Be sure to write down all changes to your system, such as service packs, hotfixes, and QFEs that have been applied. This is crucial to getting your system restored as closely as possible to what existed before the hardware failure.
Implement the following measures to help prevent or minimize the effect of a disaster
-Have your software and firmware updates available.
-Have all software disks readily available.
-Have a plan to monitor servers proactively. This is very important since orchestration instances on a failed host may not be recovered by a second host for up to 10 minutes.
-Maintain hardware records.
-Maintain software records.
Implement fault tolerance in your organization at the hardware or software level
Implementing clusters and redundant array of independent disks (RAID) helps ensure that your system can survive a hardware failure.
Archive the backup media on a regular basis in a secure location
Create a schedule for archiving your backup media on a regular basis and keep the archives in a secure, offsite location. This ensures that you have a backup available when you need it.
Verify the integrity of your backups and that they occur without error
Monitor all of your backup jobs and ensure that they complete without any errors.
Keep identical spare hardware available
Having identical spare hardware available ensures that you can quickly replace defective hardware to get up and running more quickly.
Document and test your recovery procedures
Disaster recovery testing should be conducted before ever running your system in production. Having plans in place and performing prerelease testing will ensure that your IT staff can recover your BizTalk Server systems.
Train your IT staff on disaster recovery procedures
Ensure that your IT staff is prepared to recover the system should the need arise.
Practice restoring from a backup in a test environment
Practice restoring your BizTalk Server system in a test environment to ensure that you can restore it to your production environment if a failure occurs (Microsoft, 2014).
2. Find some best practices for securing SQL Server.
Securing SQL Server.
Depends on what database you have in order to secure it.
However, securing SQL Server can be viewed as a series of steps, involving four areas: the platform, authentication, objects (including data), and applications that access the system (Microsoft, 2014).
Best practices for