====== Vytvorenie prazdneho log suboru v SQL ======

USE master

GO

EXEC sp_configure 'nazovDB', 1

GO

RECONFIGURE WITH OVERRIDE

GO

UPDATE sysdatabases SET status = 32768 WHERE name = N'nazovDB'

GO

DBCC TRACEON(3604)

GO

DBCC REBUILD_LOG('nazovDB', 'cesta k log suboru') 

GO

DBCC CHECKDB('nazovDB')

GO

DBCC TRACEOFF(3604)

GO

 

===== Ak skript prebehne bez chyby spustime nasledovne =====


UPDATE sysdatabases SET status = 0 WHERE name = N'nazovDB'

GO

EXEC sp_configure 'allow updates', 0

GO

RECONFIGURE WITH OVERRIDE

GO