Solved

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

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

756 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