Restore database having policy management rule

• pshaship

  SSCertifiable

  Points: 6125

  More actions

  September 15, 2010 at 11:58 am

  #229299

  Hi,

  What happens if we restore a database from instance1 having policy management rule on to a instance2 where NO policy management rule exist?

  Thanks

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  September 15, 2010 at 10:51 pm

  #1221889

  Nothing happens, I guess. Because policies are stored in MSDB database. Not in other databases.

  What are your expectations and concerns?

• Ali Tailor

  Hall of Fame

  Points: 3769

  More actions

  September 16, 2010 at 2:44 am

  #1221994

  Hi

  Simply policies get lost on new server of old server.

  Ali
  MCTS SQL Server2k8