• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2684
  • Last Modified:

Errors when trying to configure database mirroring

Hello Experts,

I'm trying to configuring database mirroring between two SQL Server 2005 servers.

One error I'm getting is as follows:

TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'DATA_JobTrak'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The mirror database, "DATA_JobTrak", has insufficient transaction log data to preserve the log backup chain of the principal database.  This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)


Another error I'm getting when testing with another database is as follows:


TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'SUP_Demo1'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Database mirroring cannot be enabled because the "SUP_Demo1" database is an auto-close database on one of the partners. (Microsoft SQL Server, Error: 1469)


Does anyone have any ideas on how to resolve either of the above two errors?
0
Darylx
Asked:
Darylx
  • 2
1 Solution
 
brejkCommented:
Problem #1 - You should restore your full backup taken on principal database to mirror database with NORECOVERY option. The principal database should has full recovery model set on. Also, you must assure that before mirror will get synchrionized there will be no log truncation in principal database (so you should not perform log backup there meanwhile).

Problem #2 - I would suggest to read this:

Database mirroring cannot be enabled because the "SUP_Demo1" database is an auto-close database on one of the partners. (Microsoft SQL Server, Error: 1469)

and then check if one of your databases has really auto-close option on...
0
 
DarylxAuthor Commented:
Where do I find the 'auto-close' option?
0
 
DarylxAuthor Commented:
I've got the one with the first error working.

Apparently after restoring the mirror database, if you take a separate backup of the transaction logs then restore them to the mirror server before you configure the mirror, that works.  Seems strange as the full backup/restore should restore the logs as well but it works so I'm happy.

It would be interesting to find out about the second error though.
0
 
atorexCommented:
I have the same issue with the following error can anyone help?

Database mirroring cannot be enabled because the "SUP_Demo1" database is an auto-close database on one of the partners. (Microsoft SQL Server, Error: 1469)
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now