Go to File Gallery to Download Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You’ll learn to anticipate ...

Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You’ll learn to anticipate and reduce the likelihood of a ...

I think we have a very, very large problem approaching in the IT industry. As data systems and business become more and more integrated, the concept of disaster recovery will become very, very complicated. SQL Server alone provides a means of direct integration with internal and external business partners using the Service Broker and Native ...

How do you validate what is stored in a specific partition and the filegroup the partition resides on?  I have found this handy when designing a partition strategy and to double check it is behaving as I expect and my data is stored correctly for the requirements.  It also can help if you document as part of your disaster recovery ...

Recently I had a few questions about how to go about partial restores if you have media failure that affects only specific filegroups, and your database is inaccessible because of the missing file(s).   The steps while simple, are not readily apparent in example form in books online. In this example you have a multi filegroup database ...