-- Create database sqldbpool
CREATE DATABASE [sqldbpool] ON  PRIMARY 
( NAME = N'SQLDBPool', FILENAME = N'L:\SQLDBPool.mdf' , SIZE = 5120KB , 
MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'SQLDBPool_log', FILENAME = N'F:\SQLDBPool_log.LDF' , SIZE = 3840KB , 
MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
use sqldbpool;
go
-- creating table
create table Customer
(
custID int constraint PK_Employee primary key Identity(1,1)
,custName varchar(20)
)
--Enabling CDC on SQLDBPool database
USE SQLDBPool
GO
EXEC sys.sp_cdc_enable_db
--Enabling CDC on Customer table
USE SQLDBPool
GO
EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'Customer',
@role_name = NULL
GO
--Inserting values in customer table
insert into Customer values('jugal'),('shah')
-- Querying CDC table to get the changes
select * from cdc.dbo_customer_CT
--Taking full database backup which I am going to restore for all the above scenarios
backup database sqldbpool to disk = 'l:\sqldbpool.bak'

--Restoring on the same SQL Instance with the Same database name
restore database sqldbpool from disk = 'l:\sqldbpool.bak' with replace

--Restoring on the same instance with the different database name
Restore Database sqldbpool_1 
from disk = 'l:\sqldbpool.bak' 
with move 'SQLDBPool' to 'L:\SQLDBPool1.mdf',
move 'SQLDBPool_log' to 'F:\SQLDBPool_log1.LDF',keep_cdc
--Restoring on a different instance with same database name
restore database sqldbpool from disk = 'l:\sqldbpool.bak' with keep_cdc

Use sqldbpool_1
exec sys.sp_cdc_add_job 'capture'
GO
exec sys.sp_cdc_add_job 'cleanup'
GO