Results 1 to 2 of 2

Thread: how to move a merge replicated database to a new hard disk

  1. #1
    Join Date
    Dec 2010
    Posts
    1

    how to move a merge replicated database to a new hard disk

    I am new to sql server world as system admin who is being asked to manage an asset management system at our facility. We have a system that uses SQL2005 Enterprise. My Replicated distribution database is on drive C, but it is only 10gig and it is running out of space. I have a 210 GIG hard drive as drive D. is there an easy way to move the database without deleting the publisher and the subscriptions from C to D?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can change db file path with 'alter database db_name modify file ...', then stop sql, move db files to new location and restart sql.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •