locked
Moving a database file on the Mirror only RRS feed

  • Question

  •  

    Hi - if I want to move a database file on my mirror only.  Can I just:

     

    1. Pause the mirror

    2. Detach the mirror database

    3. Move file

    4. Re-attach mirror database

    5. Resume the mirror

    Friday, October 31, 2008 11:40 AM

All replies

  • No it doesn't look like this will work, I can't detach a mirrored base or a primary base for that matter.  I guess once the mirror is created, any new files added at the primary are created in the same location on the mirror and I can't see a way to change that.  Anyone any ideas?

     

    Friday, October 31, 2008 11:56 AM
  • I guess you can make use of Alter database command as mentioned by Jonathan in the below link,
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3181365&SiteID=1

    - Deepak
    Friday, October 31, 2008 5:33 PM