June 29, 2011 at 3:04 am
Hi All,
I am trying to shrink the log files. Its not shrinking. My Hard drive is full due to the Transaction Log Size. I took tlog backup but still the space used by tlog files are not releasing.
Thanks in Advance
Omeswar Reddy
June 29, 2011 at 3:14 am
What does this return ? It will tell you why the log file is not shrinking .
select log_reuse_wait_desc
from sys.databases
where database_id = db_id()
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
June 29, 2011 at 3:49 am
Thanks for u r reply... i changed my recovery model to simple and shrink the file that resolves my problem.
June 29, 2011 at 5:10 am
odanwada (6/29/2011)
Thanks for u r reply... i changed my recovery model to simple and shrink the file that resolves my problem.
Have you done the database backup after you back to full mode.
Changing the recovery model broke the log chain.
http://sqlserverblogforum.blogspot.com/2011/03/difference-between-truncating-and.html
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 29, 2011 at 6:01 am
yes.. i took backup.....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply