drag using right click, like we move our file in explorer from one location to other

Paul,

Downtime will be there if you want the database files to be copied properly.

my strategy, if downtime allowed,

1) take primary database offline.

2) Detach it.

3) Copy file(data and log) to new location.

4) Bring your main database online to restore...

and if you want from SQL that it write script for you on the query window as well then click on any perticular table, drag it to query window and...

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...