Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

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

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
devshed
Asked:
devshed
  • 3
  • 2
1 Solution
 
TAB8Commented:
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
 
TAB8Commented:
note:  BUT If you do want to move your snapshot folder .. .make sure the subscribers can still see it
0
 
devshedAuthor Commented:
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
 
TAB8Commented:
No the identity seeds will stay the same ...   A simple detach and reattach will not edit any configuration of the database ...
0
 
devshedAuthor Commented:
Thank you for your help.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now