SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 log shipping- failover
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 08/23/2010 :  06:41:28  Show Profile  Reply with Quote
While trying to failover to a secondary node, I read that I should, if possible, take backup of transaction log and try to restore it to the secondary node, this generates a file with extension .tur All my other transaction log backups are already applied to secondary node.

When I try to apply .tur transaction log backup, it gives me error:
The media family on device 'QPS814_20100820174502.tur' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally.

Is it right way to perform the failover or am I missing something?

Edited by - mahajanakhil1985 on 08/23/2010 06:46:27

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 08/23/2010 :  06:47:59  Show Profile  Reply with Quote
I am only simulating failover.The web suggests that we get this error when the backup is corrupted, but I think that it is not corrupted.
Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 08/27/2010 :  07:31:49  Show Profile  Reply with Quote
Can somebody simply suggest me how to activate the secondary database after failover?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36601 Posts

Posted - 08/27/2010 :  13:08:57  Show Profile  Visit tkizer's Homepage  Reply with Quote
I'm not sure how you got that tur file created. To take a final backup of the primary server, just run the tlog job. Then run the copy job and finally the restore job on the secondary server. Then run a manual restore log command with recovery on that final file.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 08/30/2010 :  03:29:43  Show Profile  Reply with Quote
As I was trying to simulate failover, so I manually took the transaction log backup, which I copied on seconday site. I did not try to do so with the jobs, so it may be the reason of non-performing failover. But still I wonder how that .tur file got created when I explicitly took the backup of transaction log.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36601 Posts

Posted - 08/30/2010 :  12:52:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
You will need to post the commands that you used.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

mahajanakhil1985
Yak Posting Veteran

India
71 Posts

Posted - 08/31/2010 :  07:30:56  Show Profile  Reply with Quote
I don't know transact-SQL. So, I am using Management Studio. I have already posted the steps that I performed through Management Studio.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36601 Posts

Posted - 08/31/2010 :  11:52:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
I don't see any steps posted.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000