April 27, 2010 at 12:24 pm
Comments posted to this topic are about the item Truncate Transaction - All Databases
May 3, 2010 at 7:22 am
Hi,
It have a error in script for database with -
SharePoint_AdminContent_3a1c2e
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 !
May 3, 2010 at 9:54 am
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).
May 4, 2010 at 11:15 am
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.
Disney
May 4, 2010 at 11:19 am
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.
Att.
Disney
May 5, 2010 at 1:10 pm
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!
Ruth
May 5, 2010 at 1:33 pm
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.
Att.
Disney
May 19, 2016 at 6:57 am
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