There are huge lot of replication involved in huge lot of databases, which I'm planning to move.

So I think if I can get rid the replication rebuild, I can reduce the time window for the work.

We cannot make the DB offline or detach directly because its involved in REP.

I have an idea (Not sure its worth):

1. Make the DB RESTRICTED_USER

2. Excecute the ALTER DATABASE statement to reflect the new location.

3. Set the DB OFFLINE (Now its possible).

4. Move the file across.

5. Set the DB ONLINE (Now its up from the files at the new loc).

Not sure its worth and practical on production.

Hows it:) bright or dump?

Thanks