Showing posts with label gig. Show all posts
Showing posts with label gig. Show all posts

Sunday, March 25, 2012

cleaning out my transaction db (*.ldf)

i have an sql db which is about 400 megs the transaction log is over 2 gig. how can i bring the size down. does enterprise manager have some sort of shrink, compress or delete tool that i can use.
thank you,
ThomasTry DBCC Shrinkfile.|||Read up dbcc shrinkfile from the Holy book (SQL Server Books Online)

Also here is a reference :
http://www.dbforums.com/showthread.php?threadid=861115|||You need to back it up! After is has been backed up once or twice then you can use DBCC SHRINKFILE to reduce its size.|||If you still have a problem shrinking the log, please post back.

Tuesday, February 14, 2012

checkdb filling up tempdb

Hello all,
I have a 10 gig SQL 2000 sp3 database that is having the following problem.
The tempdb which is on the c drive is expanding past two gigs when I run my
checkdb maintenance job. This is filling the c drive and bringing down my
app. I am going to move the tempdb to another drive that has more room but
my question is why would an integrity check fill up the tempdb? I assume
this is the problem since the time stamps for the job and problem are
identical.
TIA
jjThis is By Design. Any of the DBCC checks require space in tempdb for
processing check information - this is documented in Books Online. The
amount of space is proportional to the size of the database being checked,
and the amount of active transaction log for that database. You can use the
WITH ESTIMATEONLY option to find out the minimum amount of space required in
tempdb, not counting that dependant on the transaction log size.
From the numbers you've given, it sounds like you either have a large
active log or one very large table in the database.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:eFjJS2V1DHA.2700@.TK2MSFTNGP11.phx.gbl...
> Hello all,
> I have a 10 gig SQL 2000 sp3 database that is having the following
problem.
> The tempdb which is on the c drive is expanding past two gigs when I run
my
> checkdb maintenance job. This is filling the c drive and bringing down my
> app. I am going to move the tempdb to another drive that has more room but
> my question is why would an integrity check fill up the tempdb? I assume
> this is the problem since the time stamps for the job and problem are
> identical.
> TIA
> jj
>