Monday, March 19, 2012

.trn?

Hello
I was about to backup a database and it shows a filename with fileextension
.TRN. shouldnt it be .bak?
what's .trn? never seen it before when taking a backup
/LasseLasse
Log File perhaps....
"Lasse Edsvik" <lasse@.nospam.com> wrote in message
news:OWMFx32BFHA.608@.TK2MSFTNGP15.phx.gbl...
> Hello
> I was about to backup a database and it shows a filename with
fileextension
> .TRN. shouldnt it be .bak?
> what's .trn? never seen it before when taking a backup
> /Lasse
>|||It may be backup of transaction log
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePVTz82BFHA.1264@.TK2MSFTNGP12.phx.gbl...
> Lasse
> Log File perhaps....
> "Lasse Edsvik" <lasse@.nospam.com> wrote in message
> news:OWMFx32BFHA.608@.TK2MSFTNGP15.phx.gbl...
> fileextension
>|||Its Transaction log file.
DishanF
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Trn is default extension for the Maintenance Wizard for transaction log back
ups. You can have any
extensions for the file names.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Lasse Edsvik" <lasse@.nospam.com> wrote in message news:OWMFx32BFHA.608@.TK2MSFTNGP15.phx.gb
l...
> Hello
> I was about to backup a database and it shows a filename with fileextensio
n
> .TRN. shouldnt it be .bak?
> what's .trn? never seen it before when taking a backup
> /Lasse
>

No comments:

Post a Comment