I'm trying use DBCC ShrinkFile for shrinking a log file but getting the following error:
Could not locate file 'log' for database 'db' in sys.database_files. The file either does not exist, or was dropped.
I know the context is right, I checked a number of times. Then
I used SSMS and right clicking on database and shrinking the log file from there. I chose the option release all unused space while doing it. Now it worked but 30MB log file became 500 KB. Did this operation
deleted the log file? How the file became so small?
View Complete Post