Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pete_N
Posting Yak Master
181 Posts |
 Posted - 2007-11-05 : 08:10:12
|
I have just been thrown in the deep end trying to sort out a pair of 'mirrored' SQL2005 databases. They are both running on identical machines both running windows 2003 server.The SQL servers A ( Primary ), B ( secondary ). Server A had crashed and subsequent investigations found that there was little and poor backups. The transaction logs had been allowed to spiral out of control ( one log was in excess of 100GB ). It appears that the person looking after the servers had gone into the Enterprise Manager and reset the transaction logs size, in the database properties. For what ever reason the B server would not become principal server, so i have ended up managing to recover the data for the A server, ended up clearing the b server, backing up the A server , restoring on the B server but when i try and set the mirroring i come up with the following error and am at a loss as to how to rectify it The endpoints are reported to have been set up ok Configuring Endpoints- Configuring endpoint on principal server(A) (Success)- Configuring endpoint on mirror server(B) (Success)- Configuring endpoint on witness server(WITNESS) (Success)Error when trying to mirrorTITLE: Database Properties------------------------------An error occurred while starting mirroring.------------------------------ADDITIONAL INFORMATION:Alter failed for Database 'Bossdata'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.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, "BossData", 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)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=1478&LinkId=20476I have looked at both links for help and all that i get is;We're sorry There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere. Help  |
|
|
|
|
|
|
|
Database Mirroring