motioneye
asked on
Mirrorring failed to start from management studio
Hi,
I'm in the middle of setting up the mirroring DB in sql2005, below are the step done by me
1: Create database in mirror server ( done perfectly )
2: backup principal db
3: restore mirror DB with below restore statement
RESTORE DATABASE [tRWX] FROM DISK = N'C:\Mssql\Backup\TRW3.bak '
WITH NORECOVERY, MOVE N'TRWX' TO N'C:\MSSQL2006\MSSQL.2\MSS QL\Data\TR WX.mdf',
MOVE N'TRWX_log' TO N'C:\MSSQL2006\MSSQL.2\MSS QL\Tlog\TR WX_log.ldf ',
NOUNLOAD, REPLACE, STATS = 10
4: Then restore the log
RESTORE LOG DELL
FROM DISK = N'C:\Mssql\Backup\TRW3.bak '
WITH FILE=1, NORECOVERY
GO
configure the mirroring at principal and when I click at start mirroring, windows prompt me an error below, I did try doing a restoration again and skip the step 4 but it is stil giving the same error and this DB is really fresh DB witout any data stored in it
The mirror database, "TRWX", 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)
The mirror database, "TRWX", 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)
I'm in the middle of setting up the mirroring DB in sql2005, below are the step done by me
1: Create database in mirror server ( done perfectly )
2: backup principal db
3: restore mirror DB with below restore statement
RESTORE DATABASE [tRWX] FROM DISK = N'C:\Mssql\Backup\TRW3.bak
WITH NORECOVERY, MOVE N'TRWX' TO N'C:\MSSQL2006\MSSQL.2\MSS
MOVE N'TRWX_log' TO N'C:\MSSQL2006\MSSQL.2\MSS
NOUNLOAD, REPLACE, STATS = 10
4: Then restore the log
RESTORE LOG DELL
FROM DISK = N'C:\Mssql\Backup\TRW3.bak
WITH FILE=1, NORECOVERY
GO
configure the mirroring at principal and when I click at start mirroring, windows prompt me an error below, I did try doing a restoration again and skip the step 4 but it is stil giving the same error and this DB is really fresh DB witout any data stored in it
The mirror database, "TRWX", 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)
The mirror database, "TRWX", 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)
ASKER
Hi,
I don't have any Tlog backup in schedule, or run the Tlog backup manually will that be a case??
I don't have any Tlog backup in schedule, or run the Tlog backup manually will that be a case??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Beautiful, the Tlog restore was the key. Appears to be mandatory, even with a new DB.
In the mirror, restore full backup in norecovery mode and then the transaction log backup in no recovery mode.
I always had to apply a full backup AND a transactional backup to the mirror server