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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Problem with restore with trn

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

Posted - 2009-06-30 : 13:08:51
Just use the RESTORE commands instead and if the paths are different you'll need to use the MOVE option.

RESTORE DATABASE ...
...
WITH NORECOVERY, REPLACE

RESTORE LOG ...
...
WITH RECOVERY

See BOL for details.

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

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -