Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

Question

Post reply

Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

Noman072

SSChasing Mays

Points: 600
More actions
December 23, 2024 at 12:00 am

#4489475

Comments posted to this topic are about the item Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ernst.fritz Newbie Points: 1 More actions · Answer 1

Attention, attaching a database without a log file only works if no "Memory-Optimized Tables" were used!

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 2

Quick thought: Do not use the default size and growth property values; rather, use more practical settings that fit the database's usage patterns.

😎

deubel_m SSC-Addicted Points: 469 More actions · Answer 3

In newer Versions of SQL Server and SSMS you don't need to remove the missing LDF. Please correct your article. It seems it is for old SQL Server 2005 or 2008 not for the new versions.