SQL 2005 restore TRN on new server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 28 Jul 2008 12:15 GMT

Hi,

I have the .bak and 3x .trn files from one server running a 64-bit SQL
server. This is getting moved to a 32-bit SQL 2005 server. Can someone give
me the exact procedure to restoring this please?

I can restore the .bak fine, and I've restored this in 'non-operational'
mode. But the .trn files dont restore, I get a message of

'....trn is not part of a multiple media family set' And wont let me restore.

any ideas?

thanks

Chris

Reply to this Message

TheSQLGuru - 28 Jul 2008 12:25 GMT

1) What commands, exactly, are you using for the restores?

2) Are you absolutely certain that the 3 .trn files are the first 3 trn
files backed up after the .bak file you have was created? Also are you
absolutely certain that there were no full backups taken after the .bak file
was created?

3) have you tried a test restore on the original server (to a different
database name obviously)?

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Hi,
>
[quoted text clipped - 14 lines]
>
> Chris

Reply to this Message

Chris - 28 Jul 2008 12:40 GMT

Thanks for the reply.

I am actually using the Management Console for all of this, so no commands.
But if you provide appropriate commands I am more than happy to try this.

I am certain these are the 3 x TRN files made after the .bak. a 4th one was
created during the time I was copying, but this was after the initial 3 of
course.

I haven't tried a restore and unfortunately it's tricky to do on this live
server, so hence why I'm trying it on a 2nd server.

Please advise. Thanks

Chris

> 1) What commands, exactly, are you using for the restores?
>
[quoted text clipped - 24 lines]
> >
> > Chris

Reply to this Message

Tibor Karaszi - 28 Jul 2008 13:44 GMT

> I am actually using the Management Console

I don't think you are using MMC since you say you are on 2005. I assume you are using SQL Server
Management Studio, SSMS (which is not an MMC app). SSMS has a "script" button in each dialog so you
can use that to post the commands you are executing.

> But if you provide appropriate commands I am more than happy to try this.

We don't know what commands you need to execute because there are many things specific to your
environment, like name of backup file, name of database, whether folder structure is the same on
both machine (i.e., whether you need to use the MOVE option of the RESTORE command), etc.

So, I suggest you start with posting the RESTORE commands you are executing along with the *exact*
error message(s).

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Thanks for the reply.
>
[quoted text clipped - 40 lines]
>> >
>> > Chris

Reply to this Message