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

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

GO

EXEC sp_configure 'allow updates', 0

GO

RECONFIGURE WITH OVERRIDE

GO