Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database).

  • Interview Candidate
  • 1
  • 2962

Showing Answers 1 - 1 of 1 Answers

kalyan

  • Jun 20th, 2006
 

Take an entire database backup and restore it in different instance.

Take a statistics of all valid and invalid objects and match.

Periodically refresh

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions