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 |
roykauf
Starting Member
36 Posts |
Posted - 2009-06-30 : 04:01:53
|
Hi all,Please tell me what to do:I try to restore backup + trn logs to other server . when I load the backupname.bak I don't see the following trn's associated to it. and when trying to add it manually i get this error:"exception occured while executing a transact SQL statement...the media loaded on '...trnfile.trn' is formatted to support 1 media families but 2 media families are expected according to the backup device specification. RESTORE HEADER ONLY is terminating abnormally(error:3231)"What should I do in order to backup and restore full DB backup + trn to other server? and I don't want to connect it permanently. I want to be able to restore the files to any server , any new database.Please send me ashort feedback |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|