Clean Databases (episode 8)

[Deluxor]

Hello, I think this is interesting, also its faster when importing / restoring.

All tables are clean with original structure.

Download:

You must be registered to see links

 

[Extornia]

Why did you not give credits to x30? You probably used his queries.

 

[x30unlimited]

Why did you not give credits to x30? You probably used his queries.

blah, let him be i'm used to it at least he contributed with somethin

oh and btw, eRRoR helped too, he provided the original clean query, i just fixed em

 

[Deluxor]

Why did you not give credits to x30? You probably used his queries.

No I just need to give credit to the one who posted the database dumps.

And for your info i did not used any kind of "x30" queries.

/*Disable Constraints & Triggers*/
exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
exec sp_MSforeachtable 'ALTER TABLE ? DISABLE TRIGGER ALL'

/*Perform delete operation on all table for cleanup*/
exec sp_MSforeachtable 'DELETE ?'
/*Enable Constraints & Triggers again*/
exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
exec sp_MSforeachtable 'ALTER TABLE ? ENABLE TRIGGER ALL'
/*Reset Identity on tables with identity column*/
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'

 

[x30unlimited]

you know that not all tables need to be cleaned, right ? anyway haven't tested ur db maybe others can post if it's fully workin

 

[JemCanoy]

nc release.....gonna try this

 

[y0cata]

Bro u forget to clear the 35 gb log ^^

 

[adikryan03]

@y0cata - how can you delete that 35gigs?

 

[ShadowGER]

yeah just right click your database, go to tasks and there is an option (free translation so could be another term) reduce
follow the instructions and it should be around 4 gigs or so

 

[zanthyn]

Can you reupload MultiUpload isn't working.

 

[schneemann101]

Don't working for me, used it and got everytime errors in ChatNode and GlobalMgrSvr

127.0.0.1:0

 

[toast2250]

ADVISORY: DO NOT USE any other DATABASE that has BEEN CLEANED for now except the one released by Extornia, there were reports of incompatibility issues - your experience might have been different from the others but prevention is better than cure, less headache less hassle.

Its best to use the huge default database or use the ones that you are certain they work and have been cleaned 100% properly guaranteed.

 

[Nadiell]

Don't working for me, used it and got everytime errors in ChatNode and GlobalMgrSvr

127.0.0.1:0

me to loool! i deleted original db files and i used yours and now globalmgrsvr,chatnode,agentshop,srv_01 doesn't work !

 

[Extornia]

Its best to use the huge default database or use the ones that you are certain they work and have been cleaned 100% properly guaranteed.

The databases released by me are cleaned and so are the logs. They are also set on autogrowth to increase its allocated size when necessary.

 

[basti2000]

dead link...