Thanks for your quick response, Steve
I understand that shrinking might be not a best idea. But every case is different and you never know until you've tried.

I...

Thanks a lot for your help Gail,

It is crystal clear now.

Thanks Gail,

I probably did not make myself clear.

My purpose is to take a backup of the Live database (that is over 100GB in size), while the site is under...

Thanks you all for your responds. It really brought a light to my question.

Alex

Hi Lowell,

I'm a DBA who administer all the Company databases. By 'intellectual property' I meant the scripts that are written in the databases.

The problem is that our Client requested a...

Thanks a lot to everybody,

Gila, that is exactly what I needed, thanks.

Alex

Thanks Grant,

Now I am completely lost. I was asking about the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED statement; not a snapshot isolation.

Can you advice please?

Thank you.

Alex

Thanks,

So, in other words, if I do not set my script in a transaction, but only would have the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED statement, then none of the...

That make sense, thanks Howard

And I was wondering why there are no answers 🙂

Thanks a lot.

I will re-post it in SQL2012.

Alex

It worked.

You are genious Marcus.

Thank you so much.

Alex

Thank you for all your replies.

Our intend is to implement the HA Solutions in out multi-server-database's environment with limited budget.

We do have the Mirror installed already. And we are...

Did you create a new post?

Thank you so much Lynn.

It worked. I really appreciate your help.

Alex

Jack,

Thank you so muck for your help. I totally agree that the Windows Authentication is the most secure way of handling the application pools.

Now since I'm more on SQL Developer/DBA...