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 |
|
kennetu
Starting Member
33 Posts |
 Posted - 2009-09-07 : 08:22:08
|
| Hi all,I am trying to configure database mirroring with SAFETY OFF; This is to enable me fail over to mirror server manually whenever the principal server crashes. I have taken a full and transaction log backups of the database to be mirrored from the principal server and copied across to the mirror server. On my trying to restore the full backup in the mirror server, I receive the following error messages:"The media family on device 'E:\Vtmrecon_db_mirror\vtmrecon.bak' is incorrectly formed. SQL server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server: Error 3241)."How can I work around this problem?Your prompt reply is highly valued.Regards,Kenneth. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kennetu
Starting Member
33 Posts |
Posted - 2009-09-09 : 10:13:55
|
| Thanks very much. I took another backup and it is working fine.Kenneth |
 |
|
|
|
|
|
Database Mirroring