Moving the subscription database to a new server

I would like to be able to create my subscription database locally, then
take the database offline, move it to the main server where it will actually
be located, and re-attach it.
I am assuming this isn't simple - are there any instructions on how to do
it?
before is start is it merge replication or transactional.
and SQL 2000 or 2005
"Jane Parker" wrote:

> I would like to be able to create my subscription database locally, then
> take the database offline, move it to the main server where it will actually
> be located, and re-attach it.
> I am assuming this isn't simple - are there any instructions on how to do
> it?
>
>
|||We are wanting to set it up in both SQL Server 2000 and SQL Server 2005
environments.
We have one snapshot publication and one merge replication.
Thanks
"Jacx" <Jacx@.discussions.microsoft.com> wrote in message
news:0F6B5742-2959-48DD-9042-66F2BAF30BBB@.microsoft.com...[vbcol=seagreen]
> before is start is it merge replication or transactional.
> and SQL 2000 or 2005
> "Jane Parker" wrote:

Moving Log file

I took my production database offline first, moved LDF file to a new disk
partion, re-attached the database, and pointed to new location of the Log
file. (SQL 2000, using Enterprise manager console)
It seem to be OK, but could there be a problem doing it this way?
Thanks
MC
If by "Offline" you mean that you detached the db then it should be fine.
Andrew J. Kelly SQL MVP
"MC" <webmaster@.ozoptics.com> wrote in message
news:uaouUOvRGHA.5220@.TK2MSFTNGP10.phx.gbl...
>I took my production database offline first, moved LDF file to a new disk
> partion, re-attached the database, and pointed to new location of the Log
> file. (SQL 2000, using Enterprise manager console)
> It seem to be OK, but could there be a problem doing it this way?
> Thanks
> MC
>

Moving Log file

I took my production database offline first, moved LDF file to a new disk
partion, re-attached the database, and pointed to new location of the Log
file. (SQL 2000, using Enterprise manager console)
It seem to be OK, but could there be a problem doing it this way?
Thanks
MCIf by "Offline" you mean that you detached the db then it should be fine.
Andrew J. Kelly SQL MVP
"MC" <webmaster@.ozoptics.com> wrote in message
news:uaouUOvRGHA.5220@.TK2MSFTNGP10.phx.gbl...
>I took my production database offline first, moved LDF file to a new disk
> partion, re-attached the database, and pointed to new location of the Log
> file. (SQL 2000, using Enterprise manager console)
> It seem to be OK, but could there be a problem doing it this way?
> Thanks
> MC
>

Moving Log file

I took my production database offline first, moved LDF file to a new disk
partion, re-attached the database, and pointed to new location of the Log
file. (SQL 2000, using Enterprise manager console)
It seem to be OK, but could there be a problem doing it this way?
Thanks
MCIf by "Offline" you mean that you detached the db then it should be fine.
--
Andrew J. Kelly SQL MVP
"MC" <webmaster@.ozoptics.com> wrote in message
news:uaouUOvRGHA.5220@.TK2MSFTNGP10.phx.gbl...
>I took my production database offline first, moved LDF file to a new disk
> partion, re-attached the database, and pointed to new location of the Log
> file. (SQL 2000, using Enterprise manager console)
> It seem to be OK, but could there be a problem doing it this way?
> Thanks
> MC
>