detach database while being replicated

[ProBani]

Hello guys,

I have my database file mdf in one disk which doesn't have that much free space, so I want to put this file into another disk (E. But the database is being replicated, how can I do this? Replication to doesn't be affected and move the data file into the drive where I have much free space.

Thanks in advance,
ProBani.

 

[mrdenny]

You have to stop the replication in order to detach the database.

If the only thing on the E drive is this one database file you can stop the SQL Server, move the file swap the drive letters and bring SQL back up. But that will only work if there are no other databases on this drive.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[ProBani]

thank you denny,

If I want to stop replication - can I just stop SQL Agent and then just detach database or another way better way exists to stop replication?

thanks,
probani

 

[mrdenny]

You mis-understand me. You have to completly remove and deconfigure replication to detach the database.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)