Inside Gaming

Would you like to react to this message? Create an account in a few clicks or log in to continue.

Gaming|Modding|Gossip

Please advertise our site on other forums, and Tom will personally love you for da rest of his life -.- (Admin made me do this Sad)
please donate Very Happy - https://insidegaming.forumotion.net/donate

    Making routine transaction log dumps: dump transaction

    JohnHD
    JohnHD
    Admin
    Admin


    Posts : 53
    Repo : 10009
    Join date : 2011-04-02
    Age : 28
    Location : United States

    Making routine transaction log dumps: dump transaction Empty Making routine transaction log dumps: dump transaction

    Post by JohnHD Tue Apr 05, 2011 2:09 am

    Use the dump transaction command (or its abbreviation, dump tran) to make routine backups of your transaction log. dump transaction is similar to the incremental backups provided by many operating systems.It copies the transaction log, providing a record of any database changes made since the last transaction log dump. After dump transaction has copied the log, it truncates the inactive portion.
    dump transaction takes less time and storage space than a full database backup, and it is usually run more often. Users can continue to make changes to the database while the dump is taking place. You can run dump transaction only if the database stores its log on a separate segment.
    After a media failure, use the with no_truncate option of dump transaction to back up your transaction log. This provides a record of the transaction log up to the time of the failure.
    -JohnHD

      Current date/time is Tue Jul 23, 2024 12:37 am