SQL Server 2008 R2备份恢复与验证

Create database test

go

backup database test

to disk='c:\bk\test.bak'

go

create table test..t2(id int)

go

backup log test

to desk='c:\bk\test_log_1.bak'

go

backup log test

to disk='c\bk\test_log_2.bak'

restore headeronly

from disk='c\bk\test.bak'

restore filelistonly

from disk='c:\bk\test.bak'

注意：Resore filelistonly恢复时的重要性。