全部博文
-
编辑 删除
常用sql
RESTORE HEADERONLYFROM disk='F:BKMRPDB0709150501'[@more@]-- 得到備份數據庫的信息RESTORE HEADERONLYFROM disk='F:BKMRPDB0709150501'go-- 得到備份數據的路RESTORE FILELISTONLY FROM disk='F:BKMRPDB0709150501'-- 檢查備份數據是否有效RESTORE VERIFYONLY from disk=N'F:BKMRPDB0709150501'go--把數據exec 勢行結果存出表中CREATE TABLE #TempBackupResults(BackupName nvarchar(128) ,BackupDescription nvarchar(255) ,BackupType smallint ,ExpirationDate datetime ,Compressed tinyint ,Position smallint ,DeviceType tinyin
