use Credit
backup database credit to disk = 'E:\backup\Credit_Full.bak'
select *
into ct_test
from Category
select * from Category
backup database credit to disk = 'E:\backup\Credit_Full.bak'
select *
into ct_test
from category
select getdate() -- 2009-11-10 23:49:40.373
update ct_test set category_code = convert(varchar(2), category_no)
select getdate() -- 2009-11-10 23:50:03.547
select * from ct_test
insert into ct_test values ( 'aaa', 11)
select getdate() --2009-11-10 23:50:53.297
insert into ct_test values ('bbb', 12)
select getdate() -- 2009-11-10 23:51:27.140
backup log credit to disk = 'E:\backup\Credit_Log.bak'
select getdate() -- 2009-11-10 23:51:38.863
-- 문제발생
bakup log credit to disk = 'E:\backup\Credit_RLog.bak' with name = '비상로그 백업', no_truncate
restore database CreditR from disk = 'E:\backup\Credit_Full.bak' with norecovery
restore log CreditR from Disk = 'E:\backup\Credit_Log.bak' with stopat='2009-11-10 23:50:53:297'
'Brain Trainning > DataBase' 카테고리의 다른 글
쿼리 및 시스템 튜닝 자료 (0) | 2009.11.12 |
---|---|
Sqlserver Host명 변경 (0) | 2009.11.12 |
Snapshot 생성 (0) | 2009.11.11 |
테이블 파티션 (0) | 2009.11.08 |
[Oracle] Connect by prior ... 예제 (0) | 2009.09.08 |