I need to move a database from one disk to another

The disks are on same server. The server is a subscriber. I have a 9GB
database that is replicated (Merge), and I need to move it from disk 1 to
disk 2.
I am unsure about how to correctly do this, I really dont want to damage the
replication and have to rebuild the database as the connection from Publisher
to Subscriber is a 1Mb line so could take a very long time.
I know how to use the sp_detach_db and sp_attach_db SPs but I just need to
know the best way of "pausing" replication so that I can quickly move the DB
to the larger disk.
Any instructions on how best to accomplish this move would be greatfully
appreciated.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Shane O'Connor" <Shane O'Connor@.discussions.microsoft.com> wrote in message
news:BCF5D94B-146B-4218-8B11-E060CB7EE80B@.microsoft.com...
> The disks are on same server. The server is a subscriber. I have a 9GB
> database that is replicated (Merge), and I need to move it from disk 1 to
> disk 2.
> I am unsure about how to correctly do this, I really dont want to damage
the
> replication and have to rebuild the database as the connection from
Publisher
> to Subscriber is a 1Mb line so could take a very long time.
> I know how to use the sp_detach_db and sp_attach_db SPs but I just need to
> know the best way of "pausing" replication so that I can quickly move the
DB
> to the larger disk.
> Any instructions on how best to accomplish this move would be greatfully
> appreciated.
|||the best way to do this is to drop your subscriptions and publication,
detach and then reattach your databases. and then recreate your
publications. then do a no-sync subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Shane O'Connor" <Shane O'Connor@.discussions.microsoft.com> wrote in message
news:BCF5D94B-146B-4218-8B11-E060CB7EE80B@.microsoft.com...
> The disks are on same server. The server is a subscriber. I have a 9GB
> database that is replicated (Merge), and I need to move it from disk 1 to
> disk 2.
> I am unsure about how to correctly do this, I really dont want to damage
the
> replication and have to rebuild the database as the connection from
Publisher
> to Subscriber is a 1Mb line so could take a very long time.
> I know how to use the sp_detach_db and sp_attach_db SPs but I just need to
> know the best way of "pausing" replication so that I can quickly move the
DB
> to the larger disk.
> Any instructions on how best to accomplish this move would be greatfully
> appreciated.
|||Well, thats kinda where my problem lies. In not 100% certain on how to set up
replication without the synching. Can you list the steps or a site that would
walk me thru it?
Many thanks
Shane
"Hilary Cotter" wrote:

> the best way to do this is to drop your subscriptions and publication,
> detach and then reattach your databases. and then recreate your
> publications. then do a no-sync subscription.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Shane O'Connor" <Shane O'Connor@.discussions.microsoft.com> wrote in message
> news:BCF5D94B-146B-4218-8B11-E060CB7EE80B@.microsoft.com...
> the
> Publisher
> DB
>
>