thank you, GSquared

Workgroup ed sound like a good idea

ALZDBA, if you specify 'copy' not 'move' in the db copy wizard it will not detach the source database

thank you gentlemen

i will look in to those two that you have mentioned

Actually, it's a great idea.

you see problem with that is that we have 60 databases, potentially 250

it's really time consuming and confusing to go over all those scripts and make...

Thank you, Yelena

what exactly is how YOU descibed it

Thank you(spasibo), Yelena 🙂

this is exactly what we are doing here....

i'm looking for tool that can do all this without running a t-sql scripts manually,

nice GUI interface

yep, this is the difference, right there between the Old Hand and Grasshoppers 😉

make sure that recovery model is 'simple'

exec 'checkpoint' or make any minor db conf change, it will clean up the trans log file

shrink trans log file

what do you mean by lightening? can you specify a number that you actually used?

what is the best way to determine that number?

reg your question: I'll check and will let...

thank you for the info!!!!

Gentlemen, pls clarify my confusion with our 'favorite' MP.

So how do i specify the backup retention now?

Do i have to use Cleanup History Task? i thought that it...

yes sir, that is exactly what i meant, the server's treashhold for transactions/sec, to see in what shape my database or server is, in this particular moment.

we have VERY production environment...

I LOVE THIS WEBSITE!!!!!!!!!!!!!!!!!

Thank you for your post SRB.

thank you very much, that was very helpful..

BTW is that something new,  that came in with sp3a or sp4 ?

Fellas, i couldn't believe that no one had the similar problems......

come on , talk to me...