Rafael,
Em relação ao criar backups, tudo bem, sem problemas, mas não existe essa opção na GUI de restore.
Estou tentando tambem um Partial Restore, aonde atravez do backup de um FileGroup criar uma nova base, isso ja me atenderia, mas por enquanto sem sucesso....
Estou tentando rodar este comando:
----------------------CRIAÇÃO DA BASE PRIMARIA-----------------------------------------
USE [master]
GO
CREATE
DATABASE [DB1] ON
PRIMARY
(
NAME = N'DB_1',
FILENAME = N'D:\DataFiles\DB1.mdf'
, SIZE
= 5MB , MAXSIZE
= UNLIMITED,
FILEGROWTH = 10%),
FILEGROUP [FG1]
(
NAME = N'FG_DT1',
FILENAME = N'D:\DataFiles\FG_DT1_DB1.ndf'
, SIZE
= 5MB , MAXSIZE
= UNLIMITED,
FILEGROWTH = 10%),
FILEGROUP [FG2]
(
NAME = N'FG_DT2',
FILENAME = N'D:\DataFiles\FG_DT2_DB1.ndf'
, SIZE
= 5MB , MAXSIZE
= UNLIMITED,
FILEGROWTH = 10%)
LOG
ON
(
NAME = N'DB1_log',
FILENAME = N'D:\DataFiles\DB1_log.ldf'
, SIZE
= 5MB , MAXSIZE
= 2048GB ,
FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel
@dbname=N'DB1', @new_cmptlevel=90
GO
-----------------------CRIAÇÃO DA BASE SECUNDARIA----------------------------------------
USE [master]
GO
CREATE
DATABASE [DB2] ON
PRIMARY
(
NAME = N'DB_2',
FILENAME = N'D:\DataFiles\DB2.mdf'
, SIZE
= 5MB , MAXSIZE
= UNLIMITED,
FILEGROWTH = 10%),
FILEGROUP [FG1]
(
NAME = N'FG_DT1',
FILENAME = N'D:\DataFiles\FG_DT1_DB2.ndf'
, SIZE
= 5MB , MAXSIZE
= UNLIMITED,
FILEGROWTH = 10%),
FILEGROUP [FG2]
(
NAME = N'FG_DT2',
FILENAME = N'D:\DataFiles\FG_DT2_DB2.ndf'
, SIZE
= 5MB , MAXSIZE
= UNLIMITED,
FILEGROWTH = 10%)
LOG
ON
(
NAME = N'DB2_log',
FILENAME = N'D:\DataFiles\DB2_log.ldf'
, SIZE
= 5MB , MAXSIZE
= 2048GB ,
FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel
@dbname=N'DB2', @new_cmptlevel=90
GO
------------------------CRIANDO TABELA-------------------------------------------------
USE DB1
GO
CREATE
TABLE T1(ID
INT IDENTITY(1,1), FName
NVARCHAR(20))
ON FG1
INSERT T1(FName)
SELECT 'Name1'
GO
------------------------CRIANDO BACKUP DO FILEGROUP--------------------------------------
USE
MASTER
GO
BACKUP
DATABASE [DB1]
FILEGROUP
= N'FG1'
TO
DISK = N'D:\DataFiles\Backups\Parcial\DB1_Full_FilegroupFG1Backup.BAK'
WITH
NOFORMAT,
INIT,
NAME
= N'FG1BKP',
SKIP,
NOREWIND,
NOUNLOAD, STATS
= 10
GO
-------------------------RESTAURANDO O FILEGROUP--------------------------------------------
USE
MASTER
GO
RESTORE
DATABASE [DB2]
FILE
= N'FG_DT1'
FROM
DISK = N'D:\DataFiles\Backups\Parcial\DB1_Full_FilegroupFG1Backup.BAK'
WITH
FILE = 1,
NOUNLOAD,
REPLACE, STATS
= 10
GO
Porem ao executar a parte final do restore, tenho o seguinte erro:
Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'DB2' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Fabrizzio A. Caputo
Certificações:
Oracle OCA 11g
MCITP SQL Server 2008 Implementation and Maintenance
MCTS SQL Server 2008
Developer Blog Pessoal:
www.fabrizziocaputo.wordpress.com
Blog Empresa:
www.tripletech.com.br/blog
Twitter:
@FabrizzioCaputo
Email: fabrizzio.antoniaci@gmail.com
