Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Logfile is 150GB !!!

Author  Topic 

dbaman
Starting Member

46 Posts

Posted - 2014-03-11 : 08:22:04
I have a database (Recovery Model - Simple) on SQLServer-2012. This database is replicated with Push subscription using the Snapshot Replication. The log file is 150GB whereas the database is 10GB. I tried various methods to truncate/shrink the logfile/database however none worked.

-- I took the full backup in Simple Recovery model and tried to truncate
-- I changed the model from Simple to Full took both Full as well as Transaction log backup then tried to truncate the log

Please suggest how I can reduce the size of the Logfile.

R

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-03-11 : 09:42:29
I wonder how much of the 150 GB file is actually being used. You can find out by right-clicking the db name in Management Studio --> Tasks --> Shrink Files. Check the Log file to see actual usage.
Please post back with the results.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-11 : 13:09:49
Show us the output for this query:

select log_reuse_wait_desc from sys.databases where name = 'YourDbNameGoesHere'

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -