I have two servers- sql 2005 configured in log shipping configuration. Today I found that my log shipping confiuration is broken, so I have to reconfigure it again with the wizard - this means that new backup will be performed and restored on the second server. The primary database need to be online constantly and accept the request from the users. Is this possible? DB is around 100Gb and backup/restore process takes more than 1hr.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.