mssql db .bak 복원 할 때


mssql db .bak 복원 할 때

USE [master]restore headeronly from disk =N'D:\backup\Apro_DBbada_backup_201608031722.bak'Restore FileListOnly FROM DISK = N'D:\backup\Sororo_2009_backup_201503111056.bak' RESTORE DATABASE [Sororo_2009] FROM DISK = N'D:\backup\Sororo_2009_backup_201503111056.bak' WITH FILE = 1, MOVE N'Sororo_2009' TO N'D:\databases\Sororo_2009.MDF', MOVE N'Sororo_2009_log' TO N'D:\databases\Sororo_2009_log.LDF', NOUNLOAD, STATS = 5 GO...



원문링크 : mssql db .bak 복원 할 때