Search This Blog

Google Analytics

Wednesday, July 26, 2017

Windows - Icon Not Showing Correctly Fix

If you find that icons of your applications are not showing correctly on your Windows 7, your Icon Cache may be corrupted. The Icon Cache or IconCache.db is a special database file that Windows uses to make drawing icons of applications faster without having to get from individual application each time.

To be able to get the icons displayed correctly again, IconCache.db has to be rebuilt.
  1. Launch Task Manager.
  2. Look for explorer.exe process and end it.
  3. Locate IconCache.db and delete it. In Windows 7/8, the IconCache.db file can be found at C:\Users\%Username%\AppData\Local\. (you may need to enable to show hidden files before you can locate IconCache.db).
  4. From Task Manager, click on File > New Task (Run).
  5. Type explorer.exe and then click on OK button.

Your icons should be back!

Monday, July 17, 2017

Restore Database Backup Over a Network Drive

How do you restore a Microsoft SQL database backup over a network drive without having to download to local? Since the database server is run as a service under an account that often without network access permission, it wouldn't be possible to be able to select the network drive/path when you are performing a restore. Nonetheless, we are not left without workaround.

To restore database backup over a network, you will need to run the following SQL statements using your SQL Management Studio.

--enable to show advanced options
EXEC sp_configure 'show advanced options', 1
GO
--apply changes for show advanced options
RECONFIGURE
GO
--enable xp_cmdshell
EXEC sp_configure 'xp_cmdshell', 1
GO
--apply changes for xp_cmdshell
RECONFIGURE
GO
--replace network path, username and password accordingly
EXEC xp_cmdshell 'NET USE Z: \\SERVER\Path password /USER:Domain\Username'
GO

Once the above are executed, you should be able to choose Z:\ network drive to restore your database backup file. I hope it helps.

Popular Posts