|
Hello, 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? rgds,
(comments are locked)
|
|
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.
(comments are locked)
|
|
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. Correct-o-mundo - you don't need an extension at all, it's basically a Windows convention to help the O/S use the assigned application when working with a file. You see this all the time from the other point of view when you try and open a file with an "unknown" extension and you get the Open With app. There's a checkbox with "Always use the selected program to open this kind of file". You create a relationship between an application and a file that the O/S can use going forward. It doesn't change the structure of the file in any way.
Jun 09 '11 at 05:18 AM
Blackhawk-17
(comments are locked)
|
|
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.
(comments are locked)
|
