Post reply

Need to move a database in replication

  • March 4, 2005 at 6:55 am

    #92618

    Hi,

    i have a database that is install on the c: drive. This database is in replication.

    The problem is that there's only 200 MB left on the C: drive.

    SO i whant to transfert the database from the C: drive to the D: drive.

    Is there a way that i can transfert the database without deleting the replication on the database ?

     

    Tank's

  • March 5, 2005 at 1:58 am

    #545616

    As far as I know, a database can not be easily moved without removing replication.  Neither detaching the database nor backing up, dropping, and restoring with move will work.

    Perhaps you could add additional data and/or log files to your database on the D: drive and use those for all future growth.   Would this work for you?

     

    Scott Thornburg

  • March 7, 2005 at 8:02 am

    #545733

    That's what i think.

    Thank's for the advice.

    For additionnal grow, your suggestion is right. But for now, even the database was not growing anymore, i got the same problem, i need more space.

    Well, i think that i will need to to the big job, y will remove the replication and re-create it after.

     

    Thank's

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply