Prev: dbo login not mapped to sa
Next: Is store procedure always fast than Access linked table via ODBC?
From: Chaplain Doug on 8 Apr 2010 13:26
Sql Server 2005.

I just created a new database in SQL. I imported data amoutning to about 15
MB. However, when I look at the database files associated with my new
database (Grading.mdf and Grading_log.ldf) I notice that the Grading.mdf is 7
MB and the Grading_log.ldf is 1.4 GB. I have been doing some experimentation
(adding and deleting large number of records), but the net result is that
there should still be only about 15 MB of data. How did my log file get so
large and how can I shrink it? Thanks for any help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org
From: John Bell on 8 Apr 2010 15:39
On Thu, 8 Apr 2010 10:26:06 -0700, Chaplain Doug
<ChaplainDoug(a)discussions.microsoft.com> wrote:

>Sql Server 2005.
>
>I just created a new database in SQL. I imported data amoutning to about 15
>MB. However, when I look at the database files associated with my new
>database (Grading.mdf and Grading_log.ldf) I notice that the Grading.mdf is 7
>MB and the Grading_log.ldf is 1.4 GB. I have been doing some experimentation
>(adding and deleting large number of records), but the net result is that
>there should still be only about 15 MB of data. How did my log file get so
>large and how can I shrink it? Thanks for any help.


Have you looked at http://support.microsoft.com/kb/907511/en-us

John
 | 
Pages: 1
Prev: dbo login not mapped to sa
Next: Is store procedure always fast than Access linked table via ODBC?