//
检查是否存在该数据库strDatabase数据库名称
string
strSqlName
=
"
SELECT * FROM SysDatabases where [name]= '
"
+
strDatabase
+
"
'
"
;
//
获得bak文件的日志和数据文件的信息dirPath物理路径
string
strSql
=
"
RESTORE FILELISTONLY FROM DISK ='
"
+
dirPath
+
"
\\
"
+
strDatabase
+
"
.bak'
"
;
//
执行还原的语句dirSavePath要还原到的物理路径
//
strDatabase要还原成数据库的名称
string
strSqlRestore
=
"
RESTORE DATABASE
"
+
strDatabase
+
"
FROM DISK ='
"
+
dirPath
+
"
\\
"
+
strDatabase
+
"
.bak' WITH MOVE '
"
+
strDataName
+
"
' TO '
"
+
dirSavePath
+
"
\\
"
+
strDatabase
+
"
.mdf', MOVE '
"
+
strLogName
+
"
' TO '
"
+
dirSavePath
+
"
\\
"
+
strDatabase
+
"
.ldf'
"
;
扫一扫
202
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
