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-08-11 03:32:07 发布
USE master;
GO
CREATE DATABASE mydb
ON (FILENAME = 'D:\MSSQL_DATA\DATA\mydb.mdf'),
(FILENAME = 'D:\MSSQL_DATA\DATA\mydb.ldf')
FOR ATTACH;
GO