Truncate Transaction - All Databases

  • Comments posted to this topic are about the item Truncate Transaction - All Databases

  • Hi,

    It have a error in script for database with -


    Msg 2520, Level 16, State 5, Line 1

    Could not find database 'SharePoint_AdminContent_3a1c2e'. The database either does not exist, or was dropped before a statement tried to use it. Verify if the database exists by querying the sys.databases catalog view.

    Good script !

  • Hmmm, I am trying to get away from "shrinking" anything. It is suggested that we should never shrink data files (fragmentation) and logs (breaking chain log).

  • Hi.

    I´m using all databases listed in master.dbo.sysdatabases.

    You already have a sharepoint database in past?

    Records in your master database doest´t updated.

    Check this.


  • Hi.. I agree that, but in some situations, you need to use alternatives methods.

    I make this script for automate tasks, not for "rule of tomb".

    You not need to use this everyday.



  • It works very well, except the err from SQL Server 2008:

    Msg 155, Level 15, State 1, Line 1

    'truncate_only' is not a recognized BACKUP option.

    Thanks for sharing!


  • Hi,

    Please attempt to "truncate only" is a optional variable.

    You make any changes in code for work with SQL 2008.

    Try change for "NO_LOG".

    Plase, send me your response.



  • Thanks for the script.

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

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