RESTORE HEADERONLY
FROM disk='F:BKMRPDB0709150501'

-- 得到備份數據的路
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 tinyint ,
UserName nvarchar(128) ,
ServerName nvarchar(128) ,
DatabaseName nvarchar(128) ,
DatabaseVersion int ,
DatabaseCreationDate datetime ,
BackupSize numeric(20,0) ,
FirstLSN numeric(25,0) ,
LastLSN numeric(25,0) ,
CheckpointLSN numeric(25,0) ,
DatabaseBackupLSN numeric(25,0) ,
BackupStartDate datetime ,
BackupFinishDate datetime ,
SortOrder smallint ,
CodePage smallint ,
UnicodeLocaleId int ,
UnicodeComparisonStyle int ,
CompatibilityLevel tinyint ,
SoftwareVendorId int ,
SoftwareVersionMajor int ,
SoftwareVersionMinor int ,
SoftwareVersionBuild int ,
MachineName nvarchar(128) ,
Flags int ,
BindingId nvarchar(128) ,
RecoveryForkID nvarchar(128) ,
Collation nvarchar(128)
)

declare @sql varchar(2000)

set @sql='RESTORE HEADERONLY
FROM disk=''F:BKMRPDB0709150501'''

insert into #TempBackupResults
exec (@sql)

select * from #TempBackupResults
go

-- 恢復數據庫到指定地點
restore database test
from disk='F:BKMRPDB0709150501'
with move 'ERPDB_Data' to 'e:testdb.mdf',
move 'ERPDB_log' to 'e:test_log.mdf'
go

-- 添加登錄用戶
sp_addlogin 'iemis','ooooo','test'

-- sp_droplogin 'iemis'

-- 添加權限

sp_grantdbaccess 'iemis'

--

sp_addrole

sp_addsrvrolemember 'iemis','sysadmin'

-- 查看用戶
sp_helpuser