[Emerald] SQL Log file question

New Message Reply Date view Thread view Subject view Author view
Craig Hulbert (craig@daytondigital.net)
Fri, 25 Oct 2002 17:55:22 -0400



Message-ID: <001401c27c71$37f22540$8401a8c0@janet>
From: "Craig Hulbert" <craig@daytondigital.net>
Subject: [Emerald] SQL Log file question
Date: Fri, 25 Oct 2002 17:55:22 -0400

I have a Emerald.ldf that is 5GB what is the complete method to shrink the file size of this file.. the mdf is 56MB

I try the stuff on ms's website and it only shrinks it to 4.9GB.. if its just transaction logs.. can't i kill them someway to forceably make that file smaller...

how much downtime would i expect if I do a backup, then delete, the restore ... and will that recreate everything?

thanks craig daytondigital.net

________________________________________________________________



New Message Reply Date view Thread view Subject view Author view
This archive was generated on Fri Oct 25 2002 - 14:36:52 Pacific Daylight Time