USE master;
GO
CREATE DATABASE mydb
ON (FILENAME = 'D:\MSSQL_DATA\DATA\mydb.mdf'),
(FILENAME = 'D:\MSSQL_DATA\DATA\mydb.ldf')
FOR ATTACH;
GO
SQL Server恢复mdf、ldf为数据库的方法
最新推荐文章于 2024-07-30 17:09:59 发布
USE master;
GO
CREATE DATABASE mydb
ON (FILENAME = 'D:\MSSQL_DATA\DATA\mydb.mdf'),
(FILENAME = 'D:\MSSQL_DATA\DATA\mydb.ldf')
FOR ATTACH;
GO