Welcome to Sign in | Help

Re: Fisier log foarte mare

  •  09-16-2008, 10:32 AM

    Re: Fisier log foarte mare

    As fi vrut sa evit si un backup de log deoarece fac doar un backup full.
    ce parere aveti de
    ALTER DATABASE .... SET RECOVERY SIMPLE WITH NO_WAIT
    si apoi
    DBCC SHRINKFILE('fisierlog', 0, TRUNCATEONLY)
    si iar
    ALTER DATABASE .... SET RECOVERY FULL WITH NO_WAIT

    Sorin Sandu
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems