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

 
sql-navody/navod1.txt · Last modified: 2010/03/19 12:42 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