Post reply

SQL Server 7, Transaction Log

  • July 1, 2008 at 1:53 am

    #189880

    Hi All,

    how to tuning transaction log from 70% become 20%

    thanks

  • July 1, 2008 at 1:58 am

    #836482

    Tune the transaction log? I don't fully understand what you're asking?

    Are you trying to clear out space in it?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 1, 2008 at 2:42 am

    #836510

    Mr. Gail Shaw

    How to clear out space ?

    thanks

  • July 1, 2008 at 2:44 am

    #836511

    Depends. Is your database in full recovery mode? Do you have log backups scheduled? Are they running?

    Do you have transactional replication?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 1, 2008 at 8:15 pm

    #836970

    how to make empty transaction log sql server 7

  • July 1, 2008 at 8:29 pm

    #836972

    The process for clearing this is as follows

    1) dbcc opentran(dbname) - this will show the oldest open transaction

    2) Kill this process command kill suid

    3) backup log dbname with no_log

    4) use db

    5) dbcc shrinkfile(dbname,100) - shrinks the log back to 100mb

  • July 1, 2008 at 10:01 pm

    #836982

    SQL Server 7

    DataBase : DB1

    Table : TB1

    command :

    use DB1

    dbcc shrinkfile(TB1,7)

    but I had response msg :

    Server: Msg 8985, Level 16, State 1, Line 1

    Could not locate file 'TB1' in sysfiles.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    could you help me.

  • July 1, 2008 at 11:05 pm

    #836996

    Hi there you will need to do a select * from sysfiles, this will tell you what your log filename is you must have called it something diff.

    t

  • July 1, 2008 at 11:54 pm

    #837004

    terry.jago (7/1/2008)

    The process for clearing this is as follows

    1) dbcc opentran(dbname) - this will show the oldest open transaction

    2) Kill this process command kill suid

    3) backup log dbname with no_log

    4) use db

    5) dbcc shrinkfile(dbname,100) - shrinks the log back to 100mb

    Then take a full backup immediatly as you have broken the log chain of the database (with the backup with no log) and wll no be able to do point-in-time recoveries until you take a full or diff backup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply