Relocate Log file .ldf of a replicated database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry - 27 Apr 2006 03:21 GMT

Dear Sir/Madam,
I have a replicated database which all data and log file are currently on
RAID 5, and I now would like to move the log file to another drive which is
in RAID10.
As I can't detach the database for relocate the log file, what option do I
have to relocate the log file but no needed to drop and rebuild replication?
Please kindly help! Thanks!
Henry

Reply to this Message

Paul Ibison - 27 Apr 2006 09:08 GMT

Henry,
you should be able to use sp_detach_db/sp_attach_db for this eg:
sp_attach_db 'mydb','E:\Sqldata\mydbdata.mdf','E:\Sqldata\mydblog.ldf'
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Paul Ibison - 27 Apr 2006 10:40 GMT

Actually I just tried and Hilary is right. I investigated further and there
is a way to achieve this using sp_detach_db but it involves stopping the sql
server agent and editing the sysdatabases table and would therefore not be
supported. So, your best supported bet would be to do a nosync
initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Henry - 28 Apr 2006 07:08 GMT

Dear Paul,
I would like to know the meaning of nosync initialization? As in my case,
not all objects are being replicated and it would be a huge tasks for me to
replicate everything again objects by objects and would takes a long downtime
to the subscriber also. Any suggested idea would help, thanks!
Henry

> Actually I just tried and Hilary is right. I investigated further and there
> is a way to achieve this using sp_detach_db but it involves stopping the sql
[quoted text clipped - 5 lines]
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)

Reply to this Message

Paul Ibison - 28 Apr 2006 09:25 GMT

Henry,
this article should help clarify things a bit:
http://www.replicationanswers.com/NoSyncInitializations.asp
Rgds,
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message

Hilary Cotter - 27 Apr 2006 10:20 GMT

You would have to drop replication and then detach and reattach.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

> Dear Sir/Madam,
> I have a replicated database which all data and log file are currently on
[quoted text clipped - 6 lines]
> Please kindly help! Thanks!
> Henry

Reply to this Message