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
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Anthony Perkins

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
edlunad

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.


Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy