SQL Backup File Extension

[txdave35]

Hi guys,

Recently, I had to do a SQL restore on a file that contained a BKU extension. In my experience, SQL backups have always been .bak files.

Does it really matter on the extension, or could this cause problems using a BKU extension? Thanks in advance.

 

[tlbroadbent]

Extension won't matter to SQL Server. It is good to follow convention or know the other person's standard. We use a third party backup product that utilizes a different extension. This has not been a problem.

Terry L. Broadbent - DBA

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. (Nathaniel Borenstein)