Dump transaction is not working for few database

  • To remove out filled transaction logs we use command

    dump transaction database_name with no_log

    it works properly for other database but it won't work for few database.

    It won't work for below db.

    ROSE-25-APR07

    TPC2-19

    is there any spacific database naming convention becoz of which I m failing..

    Reply soon

    Regards

    Majid

  • Hi

    Can u tell the specific error that you are getting. you can also check sql logs for more details on the error.

    My first take on the naming convention is that it should not be a problem but iam not sure abt this.

    "Keep Trying"

  • What's the compatability mode of the databases i works in and the ones it doesn't?

    Dump transaction is deprecated in SQL 2005. You should use Backup Log with truncate_only, or, even better, set the DB to simple recovery mode if you don't need point-in-time recoverability. If you do, do proper log backups

    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
  • Showing error message as

    dump transaction Rose-25-APR07 with no_log

    Server: Msg 170, Level 15, State 1, Line 1

    Line 1: Incorrect syntax near '-'.

    But it works fine if I change the name of db as Rose_25_APR07

    what will be the actual problem?

    Regards

    Majid

  • Try enclosing the DB name in square brackets

    dump transaction [Rose-25-APR07] with no_log

    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
  • Yes Gail,

    It's working..

    Thanks a lot..

    be always guided to me..

    Regards

    Majid

Viewing 6 posts - 1 through 5 (of 5 total)

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