How to shrink SAP B1 Database log file which has more than 364GB?
source link: https://answers.sap.com/questions/13019144/how-to-shrink-sap-b1-database-log-file-which-has-m.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
How to shrink SAP B1 Database log file which has more than 364GB?
Hi all,
My SAP B1 database log file has more than 364GB, and database has only 3GB but if I want to restore this database in my server, SQL displays message of to require at least 364GB free space, I tried to shrink log file but nothing changed, below are steps I followed
Open SQL Management Studio->Right click my database->Tasks->Shrink->Files->Log->then Ok
Above process does not change anything
Please anyone can help me to solve this problem
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK