mdf ldf添加到数据库
时间:2021-07-01 10:21:17
帮助过:21人阅读
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的文件安全。
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180111003357025808.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180111003357026784.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180111003357029714.png)
![技术分享](https://img.gxlcms.com//Uploads-s/new/2020-10-12-qlqqti/20180111003357030691.png)
mdf ldf添加到数据库
标签:code 分享 数据 tab mssql nbsp attach color tac