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 |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-23 : 06:41:28
|
| 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? |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-23 : 06:47:59
|
| 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. |
 |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-27 : 07:31:49
|
| Can somebody simply suggest me how to activate the secondary database after failover? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-30 : 03:29:43
|
| 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. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-31 : 07:30:56
|
| I don't know transact-SQL. So, I am using Management Studio. I have already posted the steps that I performed through Management Studio. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
log shipping- failover