
复制string.Format("backup database to disk = {1};",复制
dbName, bakFilePath) 依据备份文件创建并Restore新数据库可以使用如下存储过程实现: CREATEPROCEDURE CopyDB ( @newDbName varchar(50), --新数据库名称 @dbDataDirPath varchar(100), --数据库安装的Data文件夹目录路径 @soureDbName varchar(100), --源数据库名称 @soureBackupFilePATH varchar(100)--源数据库备份文件的
云服务器提供商路径 ) AS declare @sql varchar(3000) set @sql= createdatabase+@newDbName+ ON ( name=+@soureDbName+_Data, filename=+@dbDataDirPath+@newDbName+_Data.mdf, SIZE = 10, FILEGROWTH = 15% ) LOG ON ( name=+@soureDbName+_Log, filename=+@dbDataDirPath+@newDbName+_Log.LDF, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB ) --开始还原 RESTORE DATABASE+@newDbName+from disk=+@soureBackupFilePATH+WITHREPLACE exec(@sql) GO 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.
源码下载