SQL backup RRS feed

  • Question

  • Duirng SQL database backup, DPM creates snapshot on the same disk as database.

    Is there a way to change location of that snapshot?

    my customer has concern that it affects storage performance.

    Wednesday, April 8, 2015 11:31 AM


  • Hi,

    You can use vssadmin to move the shadowstorage to another volume.

    This example moves it from the C: drive to the D: drive

    C:\>vssadmin add shadowstorage /for=C: /on=D: /maxsize=10%

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, April 8, 2015 10:30 PM