Vytvorenie noveho SQL logoveho suboru

USE master

GO

EXEC sp_configure 'allow updates', 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_DB')

GO

DBCC CHECKDB('nazovDB')

GO

DBCC TRACEOFF(3604)

GO

Ak query prebehol v poriadku, spustite nasledovne

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

GO

EXEC sp_configure 'allow updates', 0

GO

RECONFIGURE WITH OVERRIDE

GO