SQL Server Attach DB 沒有 LDF

若不是乾淨地 Deattach，造成 ldf 和 mdf 並不一致。則沒有 ldf 時僅使用 ATTACH_REBUILD_LOG 選項仍會失敗，可以考慮 attach_force_rebuild_log 選項，例如

create database northwind on(filename=’C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2K8R2\MSSQL\DATA\Northwind.mdf’) for attach_force_rebuild_log

This entry was written by byronhu, posted on 2012 年 09 月 24 日 at 03:32:45, filed under SQL Server and tagged . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

發表留言