maybe;)

Peace: Most likely someone took a full backup somewhere in between. Full backups reset the differential base, so you have to make sure you use the correct full backup. Best...

I got my answer

Thanks all for your comments 🙂

actually my main question is this, shall I choose the previous 6 backups and restore them one by one?

Then what if I want to restore the 29th differential backup?...

Thanks for the reply 🙂

Does it mean that there's no way to set such properties in the maintenance plan?

I've created a Tuning trace and its run now

I'd like to know how I can analyze my trace. Shall I open the created trace file in DTS? Actually, can't...

it works fine now

thanks a lot

Thanks Lowell 🙂

Actually, I'd asked a developer to change her stored procedure to not to create a dynamic view many times in a cursor but immediately after she modified the...

Thanks Gail 🙂

Thanks all 🙂

ok good 🙂

Thanks Colin for the reply

You're right! it's difficult to suggest a general solution however, let me ask another question: so far as I know there are a huge amount of...

Thanks Colin for the reply

You're right! it's difficult to suggest a general solution however, let me ask another question: so far as I know there are a huge amount of...

I got it thank you 🙂

Then you mean I have to check activity monitor once and hour and count the number of connected users then calculate an average amount of that to get an idea...