.png)
Revision history [back]
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.
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
use DatabaseName
use DBNAME
DECLARE @SQLStatement VARCHAR(2000)
DBCC SHRINKFILE(DatabaseName_log, 1)TO
DISK = 'nul:' WITH STATS =/////////////////Change the Database name by the real one.
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
use DatabaseName
BACKUP LOG [DatabaseName]
DBCC SHRINKFILE(DatabaseName_log, 1)TO DISK = 'nul:' WITH STATS = 1
/////////////////Change Change the Database name by the real one.
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
use DatabaseName
BACKUP LOG [DatabaseName]
DBCC SHRINKFILE(DatabaseName_log, 1)TO DISK = 'nul:' WITH STATS = 1
Change the Database name by the real one.
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
use DatabaseName
BACKUP LOG [DatabaseName]
DBCC SHRINKFILE(DatabaseName_log, 1)TO DISK = 'nul:' WITH STATS = 1
Change the Database name by the real one.
one.
Try to do the following:following
1- Use the Shrink command
2- if the problem still exist, you can empty the log file by the following commands:
use DatabaseName
BACKUP LOG [DatabaseName]
DBCC SHRINKFILE(DatabaseName_log, 1)TO DISK = 'nul:' WITH STATS = 1
Change the Database name by the real one.