Sql-server – How to change the SQL Server Backup file (.bak) file default icon

backupformatsql-server-2012windows-server

As I would like to say that by mistake the SQL Server 2012 backup file (.bak) open with wordpad. Due to this reason all backup files of SQL Server (.bak) file change with wordpad icon in entire the Windows Server 2012 R2 Standard 64-bit O.S.

Now the SQL Server (.bak) file icon looks like as attached below:

enter image description here

To Verify the Backup File through Restore Headeronly TSQL Command

As per MSDN BOL documentation RESTORE Statements – HEADERONLY (Transact-SQL). I have checked the Restore Headeronly from Disk from verification of my (.bak) file. The

I have checked and verify through the Restore Headeronly TSQL command. The result set returned by RESTORE HEADERONLY includes a row for each of these other backup sets.

I am also attaching that screen shot for persual.

enter image description here

It seems to odd the icon format of SQL Server (.bak) file. The (.bak) file icon format through out the Server has been changed with (wordpad) icon.

My Question is that: How to revert back the (.bak) file with
their default icon format? Is it possible or not?

Best Answer

On Windows 10

  1. Right click on the .bak file
  2. Choose properties
  3. On the General tab, click the Change... button next to Opens with: enter image description here
  4. Under Other Options choose More apps enter image description here
  5. Scroll to the bottom and click Look for another app on this PC enter image description here
  6. Go the location of Ssms.exe. Mine was located here: C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio
  7. Choose Ssms.exe
  8. Click the Open button and then the Save button

It should now be associated with SQL Server Management Studio and have the icon you'd like

enter image description here

Related Question