Hi
I have one replication database and I need to move this database another
disk, but I dont wan't to remove the replication, my question is
How I can to move this database without remove the replication?"Valero" <Valero@.discussions.microsoft.com> wrote in message
news:D1B0C9DB-EBF3-41AE-8914-A5A45F37C5AC@.microsoft.com...
> Hi
> I have one replication database and I need to move this database another
> disk, but I dont wan't to remove the replication, my question is
> How I can to move this database without remove the replication?
>
Are you talking subscriber or publisher?
If you're talking subscriber, I believe you can sp_detachdb and sp_attachdb
(it's been awhile since I've had to do this.)
If you're talking the publisher, that's trickier.
What I've done is stop SQL Server, move the files, start sql server, ignore
the errors, and update the appropriate rows in the master DB, and then
restart SQL Server.
>
Saturday, February 25, 2012
Replication
Labels:
anotherdisk,
database,
hii,
ishow,
microsoft,
mysql,
oracle,
replication,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment