How to open .TRN file - SQL Server Forums

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)

How to open .TRN file

Author

Topic

mrpreethi
Starting Member

10 Posts

Posted - 2010-02-04 : 04:56:24

Hi All ,

I want to open .TRN file .Iam not able to open with notepad or wordpad .Iam very new to sql server.Please help.

Thanks,
Preethi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-02-04 : 15:56:04

You can't open a .TRN file, assuming it's a transaction log backup file. You have to restore it using RESTORE LOG, but you have to begin with RESTORE DATABASE.

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."

Kristen
Test

22859 Posts

Posted - 2010-02-05 : 02:22:07

You already asked the question here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139333

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources