Post reply

Can you change a Backup Device physical location?

  • September 28, 2005 at 11:11 am

    #168531

    I'd like to move all of my current backup devices to a new physical location (new disk) but don't appear to have the option of doing so. Is there a way of doing this without having to recreate each backup device? Could I change this manually in the sysdevices table in the master database? Thanks for any help.

  • September 29, 2005 at 5:23 am

    #593979

    Yes you can update the sysdevices table which is not a reccomended practice. However it's almost as easy to write a query against sysdevices to build a query to drop/add your backup devices as well. But is you want to execute against the system tables, here's a worthwhile reference to have on your desktop:

    http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx

     

    Also, in SQL 2K5 direct updates to the system tables are supposed go away.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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