mdf ldf添加到数据库

master; GO CREATE DATABASE NewFile ON (FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\File.mdf‘), (FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\File_log.ldf‘) FOR ATTACH; GO

3.如果出现拒绝访问，则设置下mdf 和 ldf的文件安全。