February 13, 2014 at 5:57 pm
SQL Sever is 2008R2
Database size = 38 GB
It is simple database
When I run the table size the biggest table is 81 Mb. total of tables is not even 1 gb.
Help is appreciated
February 13, 2014 at 6:56 pm
How big is the log file ??
How much free space in the database ?
February 13, 2014 at 8:28 pm
bubby (2/13/2014)
SQL Sever is 2008R2Database size = 38 GB
It is simple database
When I run the table size the biggest table is 81 Mb. total of tables is not even 1 gb.
Help is appreciated
Sounds like a runaway process or a large query blew up your log file (as previously hinted). Since your database is in simple mode you could shrink the log file to the about the size of your largest index (clustered or nonclustered), or even better (and recommended), switch to FULL RECOVERY model and start running regular transaction log backups.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply