Restore a Database with CDC Enabled

  • Comments posted to this topic are about the item Restore a Database with CDC Enabled

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

  • Hi there,

    I am going to be looking at CDC in the near future and was wondering what version of SQL Server you are using to get this error.

    Regards

    Andrew Lackenby

  • Is there a way to tell a backup file includes CDC before you restore it? or do you have to fail the restore to know?
  • You have to remember to execute the stored procedures that will create the capture and cleanup jobs as well.

  • Is there anyway of restoring and removing CDC? I was thinking you probably wont need to keep it if you are restoring to a staging environment.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply