|
Home > Archive > MS SQL Server > October 2006 > Huge transaction log - not sure why or how to fix it
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Huge transaction log - not sure why or how to fix it
|
|
|
| Hi,
I have a small database running on sqlserver express with mobile Pocketpc
clients putting in data.
The transaction log has gotten huge since changeing from MSDE to SQLExpress.
Here is the SQLPERT report:
master 0.4921875 46.8254 0
tempdb 0.7421875 68.42105 0
model 0.4921875 52.38095 0
msdb 0.7421875 46.31579 0
testdata 89764.99 0.2638862 0
How do I shrink that to something reasonalble?
I have tried shrink, to no avail.
thanks in advance,
e
| |
| Brett I. Holcomb 2006-10-24, 6:33 pm |
| What mode is the database in - Full, Bulk, or Simple (probably not
simple<G> ). If you haven't done a log backup it won't get smaller. Do a
log backup and then if necesary use shrinkfile. Get the books on line for
details.
eric wrote:
> Hi,
>
> I have a small database running on sqlserver express with mobile
> Pocketpc
> clients putting in data.
>
> The transaction log has gotten huge since changeing from MSDE to
> SQLExpress.
>
> Here is the SQLPERT report:
>
> master 0.4921875 46.8254 0
> tempdb 0.7421875 68.42105 0
> model 0.4921875 52.38095 0
> msdb 0.7421875 46.31579 0
> testdata 89764.99 0.2638862 0
>
>
> How do I shrink that to something reasonalble?
>
> I have tried shrink, to no avail.
>
> thanks in advance,
>
> e
--
Brett I. Holcomb
brettholcomb@R777bel
lsouth.net
Remove R777 to email
|
|
|
|
|