안녕하세요
밑에 글 올린 사람인데요
소이화님이 올려주신답변 2번으로 해서 tempdb까지 로드가 되었습니다.
그런데 다음디비에서 또 에러가 생기네요
그럼 댓글2번처러 /DB/db_dev1 에서
tmcenter_dev1.dat , tmcenter_dev2.dat 파일을 tempdev1 처럼 처리해 주면 될까요?
답변을 부탁드리겠습니다........ 초보라 잘 몰라서 ㅠ.ㅠ
00:00000:00001:2014/09/12 13:09:44.83 server Database 'tempdb' is now online.
00:00000:00001:2014/09/12 13:09:44.83 server The transaction log in the databas
e 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2014/09/12 13:09:45.03 server Recovering database 'sybsystemproc
s'.
00:00000:00001:2014/09/12 13:09:46.39 server Checking external objects.
00:00000:00001:2014/09/12 13:09:46.39 server The transaction log in the databas
e 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2014/09/12 13:09:46.61 server Database 'sybsystemprocs' is now o
nline.
00:00000:00001:2014/09/12 13:09:46.62 server Recovering database 'tmcenter'.
00:00000:00000:2014/09/12 13:09:50.90 kernel sddone: read error on virtual disk
3 block 616357:
00:00000:00000:2014/09/12 13:09:50.90 kernel sddone: I/O error
00:00000:00000:2014/09/12 13:09:54.01 kernel sddone: read error on virtual disk
3 block 616357:
00:00000:00000:2014/09/12 13:09:54.01 kernel sddone: I/O error
00:00000:00001:2014/09/12 13:09:54.05 server Error: 823, Severity: 24, State: 1
00:00000:00001:2014/09/12 13:09:54.05 server I/O error detected during read for
BUF pointer = '0x19d002c68', MASS pointer = '0x19d002c68', (Buf#: '0'), page pt
r = '0x19a8e3000', dbid = '4', Mass virtpage = '50948005', Buffer page = '616355
', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0
) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.
00:00000:00001:2014/09/12 13:09:54.09 server Error: 3414, Severity: 21, State:
1
00:00000:00001:2014/09/12 13:09:54.10 server Database 'tmcenter' (dbid 4): Reco
very failed. Check the SQL Server errorlog for further information as to the cau
se.
00:00000:00001:2014/09/12 13:09:54.17 server Recovering database 'tm_backup'.
00:00000:00000:2014/09/12 13:09:54.01 kernel sddone: read error on virtual disk
3 block 616357:
00:00000:00000:2014/09/12 13:09:54.01 kernel sddone: I/O error
00:00000:00001:2014/09/12 13:09:54.05 server Error: 823, Severity: 24, State: 1
00:00000:00001:2014/09/12 13:09:54.05 server I/O error detected during read for
BUF pointer = '0x19d002c68', MASS pointer = '0x19d002c68', (Buf#: '0'), page pt
r = '0x19a8e3000', dbid = '4', Mass virtpage = '50948005', Buffer page = '616355
', Mass status = '0x4000100', Buffer status = '0x1', size = '2048', cache (id: 0
) = 'default data cache', Pinning Xdes = '0x0', spid = '0'.
00:00000:00001:2014/09/12 13:09:54.09 server Error: 3414, Severity: 21, State:
1
00:00000:00001:2014/09/12 13:09:54.10 server Database 'tmcenter' (dbid 4): Reco
very failed. Check the SQL Server errorlog for further information as to the cau
se.
00:00000:00001:2014/09/12 13:09:54.17 server Recovering database 'tm_backup'.
00:00000:00001:2014/09/12 13:09:58.77 server Checking external objects.
00:00000:00001:2014/09/12 13:09:58.77 server Checking external objects.
00:00000:00001:2014/09/12 13:09:58.77 server The transaction log in the databas
e 'tm_backup' will use I/O size of 2 Kb.
00:00000:00001:2014/09/12 13:09:58.99 server Database 'tm_backup' is now online |