I am doing log shipping failover and failback configuration in SQL Server 2008 R2 environment. During the Failover, I am taking the tail log backup of primary database with query:
Script to backup Log:----------
DECLARE @filepath VARCHAR(200) SET @filePath=N'\\ClusterName\SQL_Tail_Backup\DBNAME_Tail_Log.trn' BACKUP LOG [DBNAME] TO DISK = @filePath WITH NO_TRUNCATE, NOFORMAT, INIT, NAME = N'DBNAME-Tail Log Backup', SKIP, NOUNLOAD, NORECOVERY, STATS = 10
And script for Log restore is:
Script to restore Log:--------
DECLARE @filepath VARCHAR(200) SET @filePath=N'\\ClusterName\SQL_Tail_Backup\DBNAME_Tail_Log.trn' RESTORE LOG [DBNAME] FROM DISK = @filepath WITH RECOVERY; GO
But after making secondary database writable, my applications are not connecting to the database. While, trying backup and Restore from GUI works well. Please Help!