LogDate ProcessInfo Text ----------------------- ------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2012-03-18 23:02:20.580 spid53 Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) 2012-03-18 23:02:20.590 spid53 (c) Microsoft Corporation. 2012-03-18 23:02:20.590 spid53 All rights reserved. 2012-03-18 23:02:20.590 spid53 Server process ID is 1364. 2012-03-18 23:02:20.600 spid53 System Manufacturer: 'To Be Filled By O.E.M.', System Model: 'To Be Filled By O.E.M.'. 2012-03-18 23:02:20.610 spid53 Authentication mode is WINDOWS-ONLY. 2012-03-18 23:02:20.630 spid53 Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2012-03-18 23:02:20.630 spid53 The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required. 2012-03-18 23:02:20.630 spid53 The error log has been reinitialized. See the previous log for older entries. 2012-03-18 23:02:26.710 spid53 DBCC TRACEON 3004, server process ID (SPID) 53. This is an informational message only; no user action is required. 2012-03-18 23:02:26.710 spid53 DBCC TRACEON 3605, server process ID (SPID) 53. This is an informational message only; no user action is required. -- @@ 여기서부터 복구 시작 2012-03-18 23:02:59.420 spid53 RestoreDatabase: Database testdb_restore_option 2012-03-18 23:02:59.420 spid53 Opening backup set 2012-03-18 23:02:59.440 spid53 SetTargetRestoreAge: 0 2012-03-18 23:02:59.440 spid53 Restore: Configuration section loaded 2012-03-18 23:02:59.440 spid53 Restore: Backup set is open 2012-03-18 23:02:59.440 spid53 Restore: Planning begins 2012-03-18 23:04:35.450 spid53 RestoreDatabase: Database testdb_restore_option 2012-03-18 23:04:35.450 spid53 Opening backup set 2012-03-18 23:04:35.480 spid53 SetTargetRestoreAge: 0 2012-03-18 23:04:35.480 spid53 Restore: Configuration section loaded 2012-03-18 23:04:35.480 spid53 Restore: Backup set is open 2012-03-18 23:04:35.480 spid53 Restore: Planning begins 2012-03-18 23:04:35.520 spid53 Restore: Planning complete 2012-03-18 23:04:35.520 spid53 Restore: BeginRestore (offline) on testdb_restore_option 2012-03-18 23:04:35.540 spid53 Restore: Attached database testdb_restore_option as DBID=6 2012-03-18 23:04:35.540 spid53 Restore: PreparingContainers 2012-03-18 23:04:36.300 spid53 Zeroing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore.mdf from page 1 to 12800 (0x2000 to 0x6400000) 2012-03-18 23:04:36.300 spid53 Zeroing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore_log.ldf from page 1 to 3046400 (0x2000 to 0x5cf800000) 2012-03-18 23:04:38.700 spid53 Zeroing completed on C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore.mdf 2012-03-18 23:04:38.700 spid53 Zeroing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_data_restore.mdf from page 1 to 2944000 (0x2000 to 0x59d800000) 2012-03-18 23:15:15.270 spid53 Zeroing completed on C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_data_restore.mdf 2012-03-18 23:15:15.270 spid53 Zeroing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_data_text_restore.mdf from page 1 to 256000 (0x2000 to 0x7d000000) 2012-03-18 23:15:55.990 spid53 Zeroing completed on C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_data_text_restore.mdf 2012-03-18 23:15:55.990 spid53 Restore: Containers are ready 2012-03-18 23:15:56.210 spid53 Restore: Restoring backup set 2012-03-18 23:15:56.210 spid53 Restore: Transferring data to testdb_restore_option 2012-03-18 23:15:58.950 spid53 Restore: Waiting for log zero on testdb_restore_option 2012-03-18 23:17:04.170 spid53 Zeroing completed on C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore_log.ldf 2012-03-18 23:17:04.240 spid53 Restore: LogZero complete 2012-03-18 23:17:04.550 spid53 SetTargetRestoreAge: 0 2012-03-18 23:17:04.810 spid53 FileHandleCache: 0 files opened. CacheSize: 12 2012-03-18 23:17:04.810 spid53 Restore: Data transfer complete on testdb_restore_option 2012-03-18 23:17:04.930 spid53 Restore: Backup set restored 2012-03-18 23:17:04.990 spid53 Starting up database 'testdb_restore_option'. 2012-03-18 23:17:05.330 spid53 The database 'testdb_restore_option' is marked RESTORING and is in a state that does not allow recovery to be run. 2012-03-18 23:17:05.390 spid53 Restore-Redo begins on database testdb_restore_option 2012-03-18 23:17:39.330 spid53 RunOfflineRedo logIter.Init(): FirstLsn(PruId: 0): 0x6de:0x6324:0x25 2012-03-18 23:17:39.330 spid53 RunOfflineRedo logIter.Init(): LastLsn(PruId: 0): 0x6de:0x6335:0x1 2012-03-18 23:17:39.340 spid53 OfflineRollforward: StopLsn/LastLsn(PruId: 0): 0x6de:0x6335:0x1 2012-03-18 23:17:39.370 spid53 Rollforward complete on database testdb_restore_option 2012-03-18 23:17:39.930 spid53 Restore: Done with fixups 2012-03-18 23:17:39.930 spid53 Restore: Transitioning database to ONLINE 2012-03-18 23:17:39.930 spid53 Restore: Restarting database for ONLINE 2012-03-18 23:17:40.080 spid53 Starting up database 'testdb_restore_option'. 2012-03-18 23:17:53.740 spid53 FixupLogTail(progress) zeroing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore_log.ldf from 0x57a566a00 to 0x57a568000. 2012-03-18 23:17:53.740 spid53 Zeroing C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore_log.ldf from page 2871988 to 2872000 (0x57a568000 to 0x57a580000) 2012-03-18 23:17:53.740 spid53 Zeroing completed on C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb_restore_log.ldf 2012-03-18 23:17:53.890 spid53 PostRestoreContainerFixups: fixups complete 2012-03-18 23:17:53.890 spid53 PostRestoreReplicationFixup for testdb_restore_option starts 2012-03-18 23:17:54.130 spid53 PostRestoreReplicationFixup for testdb_restore_option complete 2012-03-18 23:17:54.140 spid53 Restore: Database is restarted 2012-03-18 23:17:54.140 백업 Restore is complete on database 'testdb_restore_option'. The database is now available. 2012-03-18 23:17:54.220 spid53 Resuming any halted fulltext crawls 2012-03-18 23:17:54.280 spid53 Restore: Writing history records 2012-03-18 23:17:54.280 백업 Database was restored: Database: testdb_restore_option, creation date(time): 2012/02/10(19:23:53), first LSN: 1758:25380:37, last LSN: 1758:25397:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\testdb_simple.bak'}). Informational 2012-03-18 23:17:54.280 spid53 Writing backup history records 2012-03-18 23:17:54.360 spid53 Restore: Done with MSDB maintenance 2012-03-18 23:17:54.360 spid53 RestoreDatabase: Finished (69개 행이 영향을 받음)