.png)
حجم ال (إل دي إف) أصبح أكبر بكثير من حجم قاعدة البيانات
LDF size has been 145 GB although the data base Backup size is 3 GB, and MDF size is 3 GB
1 Answer
- Sort by
oldest newest most voted
1
Try to do the following:
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
use DBNAME
DECLARE @SQLStatement VARCHAR(2000)
BACKUP LOG [DBNAME]
TO DISK = 'nul:' WITH STATS = 1
DBCC SHRINKFILE(DBNAME_log, 1)
BACKUP LOG [DBNAME]
TO DISK = 'nul:' WITH STATS = 1
DBCC SHRINKFILE(DBNAME_log, 1)
BACKUP LOG [DBNAME]
TO DISK = 'nul:' WITH STATS = 1
DBCC SHRINKFILE(DBNAME_log, 1)
BACKUP LOG [DBNAME]
TO DISK = 'nul:' WITH STATS = 1
DBCC SHRINKFILE(DBNAME_log, 1)
/////////////////Change the Database name by the real one.
Comments