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
________________________________________________________________