Link to home
Create AccountLog in
Avatar of jc50967w
jc50967w

asked on

Not able to shrink a log file xxx.ldf ----- Urgent please

Hi Experts

The way our SQL Server database configuration is weird, anyway, the mdf, ndf, and ldf are located at D:\DATA\

Now the log file has grown up to over 100GB, and I tried to shrink it with command:

DBCC shrinkfile (N'D:\DATA\xxx_log.ldf', 18056)

 Then received an error message "Could not locate file 'D:\DATA\xxx_log.ldf' for database 'xxx' in sys.database_files. The file either does not exist, or was dropped. "

What should I do ? Urgent please
ASKER CERTIFIED SOLUTION
Avatar of edlunad
edlunad
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Anthony Perkins
>>Now the log file has grown up to over 100GB, and I tried to shrink it with command:<<
Unfortunately, you will not be able to shrink the Transaction Log until you do one of the following:
A. Change the Recovery Model to Simple (from Full) or
B. Backup the Transaction Log.