Solved

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

Posted on 2008-09-30
5
267 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
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

895 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

17 Experts available now in Live!

Get 1:1 Help Now