Truncate Transaction - All Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Disney... » Truncate Transaction - All Databases

Truncate Transaction - All Databases

Rate Topic

Display Mode

Topic Options

Author

Message

Disney Hammerschmidt

Posted Tuesday, April 27, 2010 12:24 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 24, 2012 8:56 PM
Points: 10, Visits: 116

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

Post #911351

robert.cote

Posted Monday, May 03, 2010 7:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 9:50 AM
Points: 2, Visits: 127

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 !

Post #914660

sdesai

Posted Monday, May 03, 2010 9:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 6:40 AM
Points: 7, Visits: 103

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).

Post #914785

Disney Hammerschmidt

Posted Tuesday, May 04, 2010 11:15 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 24, 2012 8:56 PM
Points: 10, Visits: 116

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

Post #915517

Disney Hammerschmidt

Posted Tuesday, May 04, 2010 11:19 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 24, 2012 8:56 PM
Points: 10, Visits: 116

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

Post #915518

Ruth Chen-435471

Posted Wednesday, May 05, 2010 1:10 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 7:40 AM
Points: 195, Visits: 243

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

Post #916388

Disney Hammerschmidt

Posted Wednesday, May 05, 2010 1:33 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 24, 2012 8:56 PM
Points: 10, Visits: 116

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

Post #916413

« Prev Topic | Next Topic »

Permissions