I manually run full back up but the file extension was mentioned as .trn hence the backup file saved with extension .trn however the same is full back up file.Can I simply rename the file extension from .trn to .bak
When I tried to rename the extension from .trn to .bak received message "If you change file name extension , the file may become unusable "...should I still can rename it from .trn to .bak file?
asked Jun 09 '11 at 04:58 AM in Default
You can change the extension. It won't change the content of the file, and as far as SQL Server is concerned, when you make a restore, it expects whatever filename you provide to be a backupfile, the extension being .trn, .bak or whatever other extension it has.
answered Jun 09 '11 at 05:00 AM
You can call backup files whatever you like.
SQL doesn't care, the only place it presumes that backup files are called trn or bak, is in the SSMS GUI - and even there you can tell it to use another file.
The error message you are getting is simple an OS warning to say that if you have assigned extensions to particular programs, then changing them might break that functionality, but in essence you are not changing the contents of the file at all.
answered Jun 09 '11 at 05:01 AM
Kev Riley ♦♦
Ditto to what @kev Riley and @magnus Ahlkvist have stated. The message you received is just that from the OS. SQL doesn't care what the file extension is called but rather that the file structure is that of a SQL Backup. If you have doubt, try restoring the file to a test server.
answered Jun 09 '11 at 05:04 AM