Solved

MSSQL 2000 MERGE REPLICATION DB MOVE TO A NEW DRIVE/FOLDER ON SAME SERVER

Posted on 2008-09-30
5
282 Views
Last Modified: 2013-11-17
Hello all,

We have an MS SQL 2000 database that needs to be moved to a new drive/folder on the same SQL server.
This database is involved in a Merge Replication scenario (the MSSQL Server 2000 being the publisher) with >100 Windows Mobile clients (merge replication subscribers) running MS SQL Server CE 2.0.

Can you suggest of ways to move the database WITHOUT breaking the Merge Replication, as it would not be okay to have >100 clients trying to sync the whole database from scratch (db size on PDAs is about 25MB).

Thank you for any and all suggestions.
Panos
0
Comment
Question by:devshed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:TAB8
ID: 22609816
all you need to do is detach the database ..

move the data and log files to their new locations ...

reattach the DB by pointing to the new datafiles ..

Replication doesnt care where the datfiles are located just the serveraname and db name has to stay the same

0
 
LVL 10

Expert Comment

by:TAB8
ID: 22609820
note:  BUT If you do want to move your snapshot folder .. .make sure the subscribers can still see it
0
 

Author Comment

by:devshed
ID: 22673896
Hi TAB8,
During the DB detach and REATTACH, is there going to be a problem with some of the replicated tables that use autoincrement columns instead of GUIDs for primary keys ?

I am looking forward to your response.
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 22676334
No the identity seeds will stay the same ...   A simple detach and reattach will not edit any configuration of the database ...
0
 

Author Closing Comment

by:devshed
ID: 31501492
Thank you for your help.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question