Forum Replies Created

Viewing 15 posts - 61 through 75 (of 195 total)

  • RE: Log LDF file

    Thanks homeBrew..

    Gail - Will APEX SQL ttol help me to read Log files which are backed up every 3 hours..

  • RE: Log LDF file

    GilaMonster (8/14/2013)


    OnlyOneRJ (8/14/2013)


    will that provide me data about who did what & what ahppened :w00t:

    No.

    Gail, Please suggest a easy plan to do where in trace n audit is not involved......

  • RE: Log LDF file

    homebrew01 (8/14/2013)


    Is 3 hour data loss acceptable for the business ? I prefer log backups every 15 or 20 minutes.

    I run a server side trace 24/7 on my production...

  • RE: Log LDF file

    Hi Gail, i am not aware of your questions.. as we are not involved in it.. just they ask us for suggestions & set the plan.. or ask us the...

  • RE: Log LDF file

    Hi Gail,

    Requirenment here is to track if any update or delete happens by mistake, for which i am asked to take Log backups every 3 hours..

    Execution of the backups finishes...

  • RE: Log LDF file

    Well... thanks for this..

    What can be done in future to avoid such things??

    Taking log backup every 3 hours will help??

    Please provide expert comments. Gail please help us making a plan...

  • RE: Log LDF file

    Somebody please suggest n help 🙁

  • RE: How to create Distribution Group in sql server 2008?

    :w00t::w00t::w00t::w00t::w00t:

  • RE: How to create Distribution Group in sql server 2008?

    Actual requirement is stated below from Client..

    =============================

    Please create new group "RnDServices_BOT" and add below users:

    abc.xyz

    bhn.iun

    jhy.pou

    ahyt.kuu

    Provide the db owner rights to this group on Below server

    VATNEWTOS01

    VATNEWTOS03

    ====================

    Please help me doing it.. as...

  • RE: How to create Distribution Group in sql server 2008?

    But i dont know how to create that, can you provide a step by step instructed manual or any link which will guide me step by step.....

  • RE: SSIS Package Error

    I asked him to download 6 lakh data.... still the package fails after transferring 5 lakh:w00t:

  • RE: SSIS Package Error

    Its just a straight export from a Table to excel file..

    it's on 64bit

  • RE: Back up

    Result found from Goggle - http://sqlmag.com/blog/does-using-checksum-ensure-successful-backup

    When the WITH CHECKSUM option is used for a backup, the backup process will test the page checksums that exist on the data...

  • RE: Application not Working

    Lynn, yes.... some junior have made the DB offline....& then he made it online..

    i dont know what must have haapened.. but the problem was with acesss.. i have granted the...

  • RE: DB Query

    Neeraj - Regarding regular Log backup is fine.. but i have no understanding abt what to set the Intial size & Autogrowth of the LDF...

    Gail - I will have a...

Viewing 15 posts - 61 through 75 (of 195 total)