Comments posted to this topic are about the item Truncate Transaction - All Databases
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).
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.
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!
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)