4

How to shrink SAP B1 Database log file which has more than 364GB?

 2 years ago
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.
neoserver,ios ssh client
Apr 01, 2020 at 05:36 AM

How to shrink SAP B1 Database log file which has more than 364GB?

379 Views Last edit Apr 14, 2020 at 08:03 AM 2 rev

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


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK