Posted on 5:11 AM by Softminer and filed under ,

Usually after a long run time of SQL service, ther process takes a lot of memory resources. by restarting the service the token memory resource will be released.

restarting can be accomplished using the

net stop
net start
A full list of the exact services is found in the registry (run regedit.exe) under the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services key.

Alternatively, you can perform the stop and start using the name that is showed in the Services Control Panel applet by putting the name in quotes, i.e.
net stop ""
net start "
Posted on 7:47 AM by Softminer and filed under , ,

you can use web Deployment tool or IIS Remote manager to migrate from one IIS server to another.

Easily right click on IIS and Deploy -> Export Server Package

  • .NET Framework 2.0 SP1 or greater
  • Web Deployment Tool
  • IIS 7.0 or IIS Remote Manager

Posted on 3:46 AM by Softminer and filed under

If you have multiple network adaptor, for example network adaptor and Lan adaptor and you want to change the default adaptor which is used by windows follow the instruction:

you have to manually add a "metric" to each interface. Windows will automatically use the interface with a lower metric. To check and change your network adapters' metric:

1. Open Command Prompt and type: route print - you will see a list of active routes, the last column displaying their "metric". Lower metric routes are preferred over higher ones.
2. Open the Network Adapter Properties (Control Panel > Network and Internet > Network Connections > right-click on adapter and choose Properties)
3. Open the properties of Internet Protocol Version 4 (TCP/IPv4).
4. Click on Advanced.
5. Untick "Automatic Metric" and set the interface metric to a number.
6. Hit OK until you close the Network Adapter properties.
7. Repeat steps 2-6 for your other network adapter(s) choosing different metrics. Remember lower metrics are preferred over higher ones.

for more information you can read: