ああ

Sql code posted
created at 31 Jan 20:29, updated at 07 Feb 16:10

Edit | Back 
1
2
3
4
5
6
7
8
9
 
USE _NOMEDB_
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE _NOMEDB_
SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (_NOMEDB_, 2000)
GO
219 Bytes in 2 ms with coderay