SqlServer-QA.net

Whether you're still in the planning stages, or you're trying to refine your organization's disaster recovery processes, this recently updated FAQ guide has information that can help. DR-Q&A

How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data in the event of a disaster. You may not be able to predict the exact details of a disaster, but you ...

Take help from BlogPost in this case that will get you more information. Log shipping and Clustering has got their own advantages, I would suggest to go through the Books online in this case to get a better understanding of these 2 HA options. Also review the blogs for High Availability for more information.

I have had an interesting discussion in SSP World about how to grant access & privileges to handle SSIS packages in a high availability and Disaster Recovery  scenario. As you may be aware that privilege involves having access to Distributed COM components as well including MsDtsServer. Few points you need to consider ...

Learn about a disaster recovery and high availability solution for conscientious IT professionals. Find out how WANsync works to protect data, and how it can ensure the integrity of both the data and the application. Download your free copy today!  

The goal of this FAQ is to offer a place for Disaster Recovery that simulates the Business Continuity provision for your SQL Server enviornment. The important factor for your DR provision is: Using backup and restore  Using DBCC, including interpreting output from CHECKDB and related commands Diagnosing and recovering from hardware ...