Welcome to Sign in | Help

Re: pot limita minim fisierul de Log (.ldf-ul) ?

  •  08-09-2007, 1:50 PM

    Re: pot limita minim fisierul de Log (.ldf-ul) ?

    eu am facut asa:

    USE master
    GO
    ALTER DATABASE DBName
    MODIFY FILE
       (NAME = DBName_Log,
       SIZE = X MB) -- unde x este 25% din Data File (.mdf)
    GO

     dupa care am observat ca oricate backupuri de transaction Log as face ....fisierul de Log se va goli dar nu va scadea ca dimensiune sub X

    multumesc mult

    alex.

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