附加没有 LDF 文件的 MDF 文件 [英] Attaching an MDF file without LDF file

问题描述

有谁知道是否有办法只附加一个 SQL Server MDF 文件(没有 .LDF)文件.数据库的日志文件被删除，我试图附加 MDF，但它不起作用.我试过运行脚本来附加文件，但没有帮助:

Does anyone know if there is a way to attach just a SQL Server MDF file (without .LDF) file. The log file for database got deleted and I have tried to attach the MDF, it does not work. I have tried running the script to attach file but did not help:

USE master;
GO
EXEC sp_attach_single_file_db @dbname = 'AdventureWorks2012', 
    @physname = 
N'C:\ProgramData\Homefront\Database\DB1.mdf';

请帮忙！！！！

推荐答案

也试试这些方法...

CREATE DATABASE AdventureWorks2012 
ON (FILENAME = N'C:\ProgramData\Homefront\Database\DB1.mdf')
FOR ATTACH_REBUILD_LOG
GO

或者试试这个...

CREATE DATABASE AdventureWorks2012 
ON  ON (FILENAME = N'C:\ProgramData\Homefront\Database\DB1.mdf')
FOR ATTACH
GO

这篇关于附加没有 LDF 文件的 MDF 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！