Solved

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

Posted on 2008-09-30
5
265 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
  • 3
  • 2
5 Comments
 
LVL 10

Expert Comment

by:TAB8
Comment Utility
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
Comment Utility
note:  BUT If you do want to move your snapshot folder .. .make sure the subscribers can still see it
0
 

Author Comment

by:devshed
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you for your help.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now