????RESTORE FILELISTONLY FROM DISK = 'E:bs8.1Dvbbs8.1.0_SQLDatasq_ebendegfzds_bkp_1.bak'
????go
?????????????г?????????.bak????????????logicalName????????.mdf??.ldf???????????"sq_ebende_data"??"sq_ebende_log"??????????????????????л??
????????????
????restore database ???????
????from disk='???????????·??'
????with
????move '.mdf???????????'
????to '.mdf????????·??'
????move '.log?????????????'
????to '.log????????·??'
????go
???????????????
???????к???????????????????????????????????′???
??????????: ??? 3234?????? 16???? 2???? 2
?????????? 'sq_ebende' ????????? 'sq_ebende' ????????????? RESTORE FILELISTONLY ???г???????????
????restore database sq_ebende
????from disk='E:Datasq_ebendeg_bkp_1.bak'
????with replace??move 'sq_ebende_data'
????to 'E:Datasq_ebende.mdf'??
????move 'sq_ebende_log'
????to 'E:\Datasq_ebende.ldf'
????go
????????????????????‘sq_ebende_bkp_1.bak’???????????????????sq_ebende???????????????????RESTORE FILELISTONLY FROM DISK ??????
??????????????????????????????????????????????????????????????????? ????????????? ?????????????????????????????????NO_TRUNCATE?????
?????? ??backup log mytest to disk = 'D:logbackupmytestmytest_last9t.trc' with no_truncate
????restore database mytest from  disk = 'D:databackupmytestmytest_52_20151222.full' with norecovery
????restore database mytest from  disk = 'D:databackupmytestmytest_52_20151222.diff' with norecovery
????restore log mytest from disk = 'D:logbackupmytestmytest_last9t.trn' with recovery??stopat = 'xxxxxx'
??????????????????β???????????? RESTORING ???????????????δ?? ???????????????????????? ???????NORECOVETY???????б?????????NO_TRUNCATE???????????????????????????
????????backup log mytest to disk = 'D:logbackupmytestmytest_last9t.trn' with norecovery??no_truncate
????restore log mytest from disk = 'D:logbackupmytestmytest_last9t.trn' with recovery??stopat = 'xxxxxx'
?????????????????????????軹???????????????????????????????????
????????????????????????????????????????????????????????????????????????????????????????????????????????????