Highlighted
Nitesh_Turkar
2 Bronze

SQL log backup promoted to FULL every time in DB mirror configuration.

Jump to solution

Hi All,

We are backing up SQL 2012 mirror system. We backup both nodes in cluster and backup configured with Virtual name.

We have SQL server configured in Cluster and running the backup with Virtula name.

Backup was working fine as FULL and LOG (INCR). now after configuring Mirror with this DB we start getting issue with LOG backup (INCR).

Every time I initiate LOG backup it does show INCR in NETWORKER console but takes full backup of the DB and logs not getting truncate.


I know with log shipping option I should face this kind of issue but not with Mirrioring configuration.

T Log shipping does include backup operation and brake the chain so in next incr backup it does FULL but it should not work like this in Mirrioring configuration.


Networker server 8.2.1

NMM version - 8.2.1 (Backup configured through SQL VDI)


it's not AOAG it's just a Database Mirroring.

So I have configured the backup with same user and credentials which is used for configure SQL DB mirror.

2 Prod server in cluster and 1 DR server which we are using to send the logs.

on all nods I am using same user and networker services started with the same user name and password.

FULL backup is working fine but when I initiate an INCR backup it promoted to full.

Following error message I am getting once the backup is completed.

8008:(pid 10364):One or more arguments are not correct.

29085:(pid 10364):Microsoft SQL Server Provider error:

38006:(pid 10364):SQL Server Network Interfaces: The target principal name is incorrect.

38006:(pid 10364):Cannot generate SSPI context.

66212:(pid 10364):Cannot login to SQL Server DRserver\DBname.

29085:(pid 10364):Microsoft SQL Server Provider error:

38006:(pid 10364):Invalid authorization specification.

66212:(pid 10364):Cannot login to SQL Server DRserver\DBname.

37786:(pid 10364):Unable to determine status of mirror partner backups for database 'DBname'.  Backup level forced to full.

Note: I am using the same user and password which is used for configuring DB Mirror.

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
Nitesh_Turkar
2 Bronze

Re: SQL log backup promoted to FULL every time in DB mirror configuration.

Jump to solution

Hi Guys,

Thanks for your inputs.

I manage to run the backup for this configuration.

Now backup is configured for SQL mirror setup and INCR working fine with Log truncation.

Issue with user that SQL team used to configure the Mirror. That user was not registered with SPN. After manual SPN registration for user on domain able to achieve log backup with this configuration.

View solution in original post

3 Replies
abdul.manaf
1 Copper

Re: SQL log backup promoted to FULL every time in DB mirror configuration.

Jump to solution

Hi Nitesh,

Provide the  administrator username and password of the SQL Server in the client properties>>apps&modules window

0 Kudos
Nitesh_Turkar
2 Bronze

Re: SQL log backup promoted to FULL every time in DB mirror configuration.

Jump to solution

Hi Guys,

Thanks for your inputs.

I manage to run the backup for this configuration.

Now backup is configured for SQL mirror setup and INCR working fine with Log truncation.

Issue with user that SQL team used to configure the Mirror. That user was not registered with SPN. After manual SPN registration for user on domain able to achieve log backup with this configuration.

View solution in original post

ble1
6 Indium

Re: SQL log backup promoted to FULL every time in DB mirror configuration.

Jump to solution

Thank you for sharing.

0 Kudos