ee1f184a   
   XPost: microsoft.public.sqlserver.programming, comp.databases, m   
   crosoft.public.sqlserver.server   
   From: jasen@xnet.co.nz   
      
   On 2011-01-31, Query Builder  wrote:   
   > I use Database mirroring extensively in my disaster recovery site. I   
   > have my primary site and DR site in different geographical location.   
   > So far the mirroring is been  stable and does the job without any   
   > manual intervention. We have implemented TDE and I am able to set the   
   > mirroring with the certs installed on both primary and DR.   
   >   
   > But now I have a situation that my database backups have grown to be   
   > big because of the TDE.. The issue I have is the need to resynch the   
   > database each time I had to do a DR Drill to take the standby DB out   
   > of mirror or database maintenance such as adding a file group to the   
   > db, etc... It takes me a day to get the backups copied over or ship to   
   > the DR site.   
   >   
   > Just wondering how people who deal with VLDB's with situations like   
   > this. Is there a way for me to do a planed DR Drill but to minimize   
   > the downtime of being without the DR site for a long period of time?   
   >   
   > Any advise would greatly be appreciated..   
   >   
   > Thanks in advance..   
   > Aravin Rajendra.   
      
   at the recovery-site have a readable hot-standby and for the drill   
   use snapshot copy of it   
      
   this means the disks at the recovery site need to be big enough for   
   two copies of the database.   
      
   --   
   ⚂⚃ 100% natural   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)