You can do the defrag because it will not cause the log file to grow huge.

great, thanks a lot for discussion

Guys,

Great discussion. Thanks a lot for detail discussion

recently I have seen some job post SQL DBA + SAP Basis and good PAY

I understand that depends on project and what...

Good answer I too agree with u

can any one reply on this question.

All,

Thanks for your advice...

I did the alter with Option 1, in my case sync up did not take much time because both servers are in same data center.

I need to...

thanks for the advice.

Your advice looks good

can you tell me what is the dis advantage of option2

No, This is not interview question...

I am just searching find alternate ways to recover for different scenario.

There might be solution

there is no T-Log backup

P Jones (7/31/2009)

So have you genuinely earned the MCITP qualification or are you just another committing the crime of deception?

It may make someone...

Thanks...

Jeff,

I knew some ways to get rid of tempdb issue.

Why I posted the question is,

Who expects reply to this quesion.

I agree with you, I am still learning SQL...

can you post some sample error message

can you post the sample error message....

I did not get your question

I assume that you want to know that your physical disk drives like C:, E: disk capacity and free space If I am right..