SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to create .TRN file in sql server 2005
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mrpreethi
Starting Member

10 Posts

Posted - 02/04/2010 :  02:25:04  Show Profile  Reply with Quote
Hi All ,

How to create .TRN file in sql server 2005 using sql server management studio?Also once created how to read it ?Iam very new to SQL Server.Please help......

Kristen
Test

United Kingdom
22431 Posts

Posted - 02/04/2010 :  02:33:30  Show Profile  Reply with Quote
What do you think that you want a .TRN file for?
Go to Top of Page

mrpreethi
Starting Member

10 Posts

Posted - 02/04/2010 :  02:36:52  Show Profile  Reply with Quote
Actually ,iam very new to SQL Server DBA .Iam asked to open a trn file which exists in production server.In development i dont have .trn file .So i want to create .trn in dev server and try to open the same .Please help
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 02/04/2010 :  03:12:29  Show Profile  Reply with Quote
problem is a TRN file could be anything.

Most commonly it is a Backup of the Transaction log. Seems odd that you are being asked to "Create" a TRN file if what they want is a Backup - I would have expected them to say "Make a backup" instead.

Which is why I asked what you think they are asking you to do. Perhaps you should get them to clarify? My question would be "Do you want me to make a transaction backup? set up a scheduled transaction backup every 15 minutes? or something else ..."
Go to Top of Page

mrpreethi
Starting Member

10 Posts

Posted - 02/04/2010 :  05:01:38  Show Profile  Reply with Quote
I clarified ..Its just that i need to open .TRN file .but iam unable to open with notepad or wordpad .
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 02/04/2010 :  08:29:25  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
If it's a transaction log backup file, then it can't be simply opened. It's part of a backup set. It's something that you would use when restoring a database from a backup.

I think you need to go to the person who asked you to open it and get more details on what it is they want you to do.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 02/04/2010 :  09:53:29  Show Profile  Reply with Quote
For example, you could create a new, temporary, database and restore to that.

however, you can't restore a Transaction log backup file on its own. You must first restore a FULL Backup, then you can Restore one, or more, transaction log backups files after that (but they must be restored in chronological order and no files must be left out).

But I'm sure this is still not the answer to the question - because you would need a Full backup file too, and I'm sure the person who is asking you to do the job would know that.

So I think we are still not clear what you are being asked to do.

If you ONLY have a Transaction Log backup there is pretty much NOTHING that you can do with it (you could get a Transaction log Reader, but reading one TRN file, in isolation, is not going to make much sense)

SQL has a command to check what is "in" a Backup file, so you could use that to examine the header(s) in the file

RESTORE HEADERONLY FROM DISK = N'X:\Path\YourFile.TRN'
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000