«
»

Restoring a SQLServer database that uses Change Data Capture

Posted by Jugal Shah on June 27, 2011


Problem
When restoring a database that uses Change Data Capture (CDC), restoring a backup works differently depending on where the database is restored. In this tip we take a look at different scenarios when restoring a database when CDC is enabled.

Solution
For solution, please check my new article on MSSQLTips.com

http://mssqltips.com/tip.asp?tip=2421

This entry was posted on June 27, 2011 at 8:25 am and is filed under DB Articles, SQL Server 2008, SQL Server 2008 R2, SQL Server 2011 (Denali). You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out / Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out / Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

«
»
 
Follow

Get every new post delivered to your Inbox.

Join 174 other followers