[thelist] Shrink MS SQL Server ldf file

Arthur Maloney ArthurM at seipas.com
Tue Aug 23 22:20:39 CDT 2005

Hello thelist,

  I've inherited a Sql Server 2000 database a standard backup of it is  5.3gig (7gig mdf)
  Its been in use for 3-4 years and never had a transaction log backup. The ldf file is 63Gig

  How you shrink an ldf file? I suspect its true size is quite small.

Best regards,
 Arthur                          mailto:ArthurM at seipas.com

More information about the thelist mailing list