Backup 및 Restore

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'