DB 이관시 설정상태 체크, 변경

restore filelistonly from disk='H:\temp\DBNAME_FULL2.BAK'

restore database DBNAME from disk='H:\temp\DBNAME_FULL2.bak'
with move 'TEST_Data' to 'K:\SQL_DATA\DBNAME.MDF',
move 'TEST_Data_Log' to 'N:\LOG_DATA\DBNAME_log.LDF'


--논리적이름 변경
ALTER DATABASE DBNAME MODIFY FILE ( NAME = 과거이름_Data, NEWNAME = DBNAME );
GO
ALTER DATABASE DBNAME MODIFY FILE ( NAME = 과거이름_Log, NEWNAME = DBNAME_LOG );
GO

--자동증가 변경
ALTER DATABASE DBNAME
MODIFY FILE ( NAME = 'DBNAME', FILEGROWTH = 128MB )
GO
ALTER DATABASE DBNAME
MODIFY FILE ( NAME = 'DBNAME_log', FILEGROWTH = 64MB )
GO

--vlf설정 최적화(가능하다면)
dbcc loginfo('DBNAME')
ALTER DATABASE DBNAME SET RECOVERY simple

use DBNAME
dbcc shrinkfile ('DBNAME_log', 0, TRUNCATEONLY) --로그파일 갯수를 줄인다.

ALTER DATABASE DBNAME MODIFY FILE (NAME = N'DBNAME_log' , SIZE = 256MB);  --로그파일 사이즈를

ALTER DATABASE DBNAME SET RECOVERY FULL

BACKUP DATABASE DBNAME TO DISK='d:\BDBNAME_FULL.BAK' WITH INIT