Mirror

is it possible to have a mirror of database in SQL SERVER 2000? thanks! so if i inserted a record in the first database, it will also be inserted on the other oneThere is nothing like a Mirror definition out in SQL Server. What we can do is to create two databases and have a Replication configured as a publisher and subscriber model. So when the publisher has a change the subscriber is notified of the changes and replicated.

Search for replication in SQL Server BOL for types of replication and the options available for the same.