sp_helpfile

1) Its better to design the package for daily import/export. Why? More reliable and easy to monitor and implement. Also during migration in same environment you can simple move your...

please ignore it. worng place worng post.

what type of replication is configured? And how about running dbcc between latency, if you know that in idle condition it not take more than 2 min?

I am assuming that...

if you cant make it similar to principal then the name should not be mirroring....isnt it :w00t::w00t::w00t:

Is it active/active or active/passive cluster?

no its sql server 2000....

but interested to know that there is different result of query in different version/sps

ohhh great. Thanks for reply...... I am truly not professional....left the crown for you....:w00t::w00t::w00t::w00t::w00t:

The question was about service pack difference in query result.....

:-D:-D:-D:-D

asking the admin.....OK, I will tell someone in my admin team to provide the answer on this site 😉

ok thanks for the reply.....

let me further explain.......there was IO bottleneck which get resolved but the problem is there are some reports which if I run at actual server will...

100% true... was isolated to my environment :w00t:

what do you mean my top running :w00t:

I think sp_lock give you valuable information and based on that you can investigate further

😛

Thanks to all for their valuable update.

So what I understand is Differential backup is important but not hard and fast. What is important is your log backup must be...

Thanks for so quick response.

But my only point is running differential backup for big database and highly transactional database, will impact the performance....