Yes, I'm just wondering if there is a way not to restart the server just to rebuild the TempDb... Anyways, well it would be better if there is a script...

Hi Greg,

I believe that I do not have this Snapshot Isolation in my SQL Server 2000 yet my databases are not replicated to other machines as well. The problem I'm...

Hi Guys!

I do sincerely appreaciate your replies.

Well after having the changes from my databases, from FULL to SIMPLE, as of now...

Thanks!

btw, what if i add new transaction log file from the database? does it help the performance of my database specifically allocation of the transaction logs? or it will give...

"You are currently only backing up the data file once per day?" - Yes, complete backup every 2am.

"then consider setting your recovery model to simple" - Yes, will adopt this...

Hi, I have some questions again in mind regarding your suggestions:

1. "running periodic transaction log backups between full or differential backups" - do you mean that i should run every...

"fast growth" well this means that the transaction log file is getting bigger and bigger in a minute say i've started at 1mb then after a while in 5 minutes...

thanks for the reply but allow me to say these screnarios in my way.

1. backup, i've created a backup maintenance plan every 2am then the backup file goes to my drp...