The Way for Clearing the Log Disk

Posted on Edited on In Views:
This article shows you the sql scripts that cleared the sql log disk.​

The example SQL script code as shown below:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
use [AxDB]

SELECT name FROM sys.database_files

USE [master]
GO
ALTER DATABASE [AxDB] SET RECOVERY SIMPLE WITH NO_WAIT
GO

USE [AxDB]
GO
DBCC SHRINKFILE (AxDB_Restore_log, 1024)
GO

USE [master]
GO
ALTER DATABASE [AxDB] SET RECOVERY FULL WITH NO_WAIT
GO