sqlserver2008通过mdf与ldf还原数据库

sqlserver2008通过mdf与ldf还原数据库

USE master;
 GO
 CREATE DATABASE CardioScansEerver
     ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\CardioScanServer.mdf'),
     (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\CardioScanServer.ldf')
     FOR ATTACH;
 GO

注意，执行命令之前需要把mdf与ldf放在命令指定路径下。

posted on 2016-01-09 14:15 Juniors 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/sunyt/p/5116335.html