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 4
pma111Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.