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

 
vytvorenie_prazdneho_sql_log_suboru.txt · Last modified: 2010/03/19 12:52 by 192.168.10.135
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki