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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.