Mirror Database Properties

Question

I am having a problem with a single database on my SQL Server 2005 server.

Several databases have already been configured for mirroring, however, when I right-click and go to properties in SSMS, there is no Mirroring property page in one particular database.

I performed common tasks, such as setting up a full recovery model, fully backing up a database, and backing up logs.

I do not see that this is a problem with the server, as other databases happily reflect.

I looked around and I do not see that I am missing the settings, any help would be appreciated.

Thanks.

EDIT: now this is not related to the mirror database, I can’t get to the definition of the mirror database, I don’t see the Mirroring page by principle.

EDIT: I was able to configure mirroring using t-sql commands. However, I still do not see the Mirror Page.

UPDATE: this also applies to the option to send transaction logs. I can successfully configure it in SQL, but not through SSMS.

Answer 1

In the end, I had to contact Microsoft support for a problem that I encountered. In any case, after some time and several support sessions, they found out that the database with the problem had identifier 4 in sys.databases. Identifiers 1-4 are usually reserved for system databases, and if the database has any of these identifiers, the T-log or Mirroring properties are not displayed. So for some reason, our database got identifier 3, and now I better connect and disconnect and reconnect some databases to reassign identifiers.

Answer 2

Check out those points:

2. The mirror database must be created from a full backup of the primary server and must be restored in the "Restore with Norecovery" model. It is followed by the restoration of the backup of the transaction log of the main database so that the sequence numbers of the mirror logs and the main database are synchronized with each other.
3. The mirrored database must have the same name as the primary database.
... 8. Database mirroring is available in Enterprise, Developer, and Standard Editions, however, refer to the Microsoft website for a comparison chart, as some features are not available in the standard version. SQL Server Workgroup and Express Edition can only be used as witness servers.
Database Mirroring in Microsoft SQL Server 2005

Testing with sp_dbmmonitorresults (Transact-SQL)

Answer 3

I have no answer, but yesterday I came across the same symptom, and I remembered your question here, ha ha ha. My problem was that I configured the database mirroring using the wizards, but on one of the systems there was a firewall blocking the mirroring port. The master went all the way to the last part of enabling database mirroring, and then with an error - but at that point the mirroring was already configured. Mirroring worked fine, but there was something not entirely correct in the database metadata. Even when I removed the firewall, parts of the SSMS acted as if mirroring were not configured for this particular database, even if it was.

Then I set up additional databases for mirroring (with the firewall turned off), and they worked fine. My solution was to remove the mirroring in this database and then add it again and it worked fine. It doesn't seem like this worked for you.