Stephen Weber - MCSE, CCNA
asked on
Srink Log File in SQL 2005
One of our log file grew to 200 gigs due to a failed backup, I backed up this file and reduced the file size using the task menu in SQL Server Manager using the options in the attached image, the action successfully completed, but when I check the size, the log file has not been reduced in size
SQL2005SrinkFile.jpg
SQL2005SrinkFile.jpg
Did you perform a transaction log backup or a full backup?
ASKER
I performed a log backup and then full backup the night before, and a log backup after shrinking the file, but have not done a full backup since attempting the shrink.
The log backup should be BEFORE the shrink.
Back up database
Backup log
Shrink log if you need to
Backup log
Shrink log if you need to
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.