Restore database Multifiles,Full and differential restore keep_CDC
Definition Description
sql server The WITH MOVE clause can be used to locate one or more files. Full ve Differential restore WITH CDC TABLES USE [master] RESTORE DATABASE [GURMEN] FROM DISK = N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\Backup\GURMEN\GURMEN_backup_2017_03_01_001001_0367937.bak' WITH FILE = 1, MOVE N'GURMEN_Data' TO N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\DATA\GURMEN_Data.mdf', MOVE N'NonClusteredIdxFile' TO N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\DATA\NonClusteredIdxFile_data.ndf', MOVE N'CDCTBLOGFILE' TO N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\DATA\CDCTBLOGFILE.ndf', MOVE N'NEBIMLOGTBLFILE' TO N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\DATA\NEBIMLOGTBLFILE.ndf', MOVE N'GURMEN_Log' TO N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\DATA\GURMEN_Log.ldf',NORECOVERY, NOUNLOAD, STATS = 5 RESTORE DATABASE [GURMEN] FROM DISK = N'S:\SQL\DATA\MSSQL12.MSSQLSERVER\MSSQL\Backup\GURMEN\GURMEN_backup_2017_03_17_020201_5670060.diff' WITH FILE = 1, NOUNLOAD, STATS = 5,KEEP_CDC
