Distribution Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msnews.microsoft.com - 06 Mar 2008 19:41 GMT

Can I move the Distribution Database from one location to another without
impacting replecation.?

Thanks

Reply to this Message

Kevin3NF - 06 Mar 2008 19:57 GMT

Location - meaning drive, or server?

Signature

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

> Can I move the Distribution Database from one location to another without
> impacting replecation.?
>
> Thanks

Reply to this Message

msnews.microsoft.com - 06 Mar 2008 20:09 GMT

to a new drive on the same server

> Location - meaning drive, or server?
>
>> Can I move the Distribution Database from one location to another without
>> impacting replecation.?
>>
>> Thanks

Reply to this Message

anxcomp@gmail.com - 06 Mar 2008 22:17 GMT

Hi,

I'v moved in this way:

1. Run ALTER DATABASE database_name SET OFFLINE WITH ROLLBACK
IMMEDIATE.

2. Move the file to the new location.

3. Run ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name,
FILENAME = 'new_path/os_file_name'.

4. Run ALTER DATABASE database_name SET ONLINE.

Reference -
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/89f01b10-5fae-4ed8-
b0fb-a4b9f540fd28.htm

http://groups.google.pl/group/microsoft.public.sqlserver.server/browse_thread/th
read/89b28d54a808c91e/

--
Regards

Reply to this Message