Looking to bakcup and restore application roles

• alnickels

  Newbie

  Points: 1

  More actions

  July 16, 2014 at 11:29 am

  #98844

  Is there a way to backup and restore application roles from a SQL server 2000 instance and restore to another SQL server? When I did a previous restore of the database the Roles were created for all cases except for the application Roles.

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  July 17, 2014 at 11:12 am

  #1730362

  I find this odd since application roles are stored inside the application database system tables.

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