sql backup files non-default extensions

could a backup of a sql server have an extension .sql, and would there be any benefit in saving backups as SQL files? I am doing a risk assessment on  some files found on shares on a database server, and some have dbbackup in the name, but not the traditional .bak extension, rather they are .sql. I will query it with the DBA but wondered if they could represent actual SQL backups, and if so why would someone save them as .sql as opposed what seems to be the standard .bak.
LVL 3
pma111Asked:
Who is Participating?
 
Shaun KlineLead Software EngineerCommented:
There would be no benefit to saving a backup file as .SQL except if it was a SQL script. Note there are programs that backup databases that use other extensions.

If the files are small, the files may be scripts for performing the backup.
0
 
pma111Author Commented:
Not small almost 30gb which didnt look like a script.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The extension is just to help you identify the type of files that you are dealing with. For the engine it does not matter at all as far you provide the full file name with the extension you used.
Is not because is .sql or .txt. or .xls or any other extension that it will not Restore properly. What really matters is the header of the file, where is all the necessary information for the engine to perform a proper Restore.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
pma111, do you still need help with this question?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.