The following instructions can be used to set up a rotating snapshot schedule for all the Virtual Machines that are running in Hyper-V on the server. The default rotation for this script is 7 days which can be modified depending on your preference.   Warning In order for this script to run successfully, you will…

use tempdb GO DBCC FREEPROCCACHE — clean cache DBCC DROPCLEANBUFFERS — clean buffers DBCC FREESYSTEMCACHE (‘ALL’) — clean system cache DBCC FREESESSIONCACHE — clean session cache DBCC SHRINKDATABASE(tempdb, 10); — shrink tempdb dbcc shrinkfile (‘tempdev’) — shrink db file dbcc shrinkfile (‘templog’) — shrink log file GO — report the new file sizes SELECT name,…

I recently had this problem, and even after ensuring that the bindings for the website were linked to all unassigned addresses, I could still only connect via the loopback address, 127.0.0.1. The first troubleshooting step was to look at all listeners using: netstat -an I noticed I had an entry for port 80 for 127.0.0.1,…

This scenario is for After Restoring TFS Database 2013 Open Database instance in Sql Server Management Studio and open database TFS_Configuration Go to tbl_ServiceHost table and look for entry where Name  = “TEAM FOUNDATION”. Copy the HostId Go to TFS INSTALL FOLDER \Application Tier\Web Services folder Open the web.config and update the value for applicationId…

Since the first time computers were networked together, people have had to test their connections. Just like a dial tone that tells you the phone is ready to use, many IT pros want to make sure they have a remote connection before beginning their ‘call’. For IT pros, this has traditionally meant using the PING utility that…

This issue will occur if the dependency services are disabled. Please make sure the following services are enabled and running. –      DNS Client –      Function Discovery Resource Publication –      SSDP Discovery –      UPnP Device Host We can see from the security logon that successful connections are using Package Name (NTLM only):    NTLM V2 On the Server…

Batchfile :: This batch file stops CAB and CPS files filling up temporary storage caused by Trusted Installed and Windows Update services. @ECHO OFF :: Title for Batch Script title The Fumigator :: Display Text Echo Executing The Fumigator, hold your breath. :: Stop Windows Update Service net stop wuauserv :: Delete all files/folders WITHIN…

COURSE OVERVIEW In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure. This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can…

I had this issue on a server.   I shifted through the event log and found the pattern of events that preceded the issue, and, probably, caused it. In short, the pattern is as follows: Windows updates run automatically as scheduled, and when reboot is initiated after the updates are finished, the computer crashes (probably…

For IIS6 web server that is hosting two application pools. Occasionally, one of the w3wp processes will spike the CPU for a while, and both app pools seem to suffer the consequences. Goto cmd window then type c:\windows\system32\cscript c:\windows\system32\iisapp.vbs For IIS7 you need to use APPCMD from %systemroot%\system32\inetsrv\ as an administrator   %systemroot%\system32\inetsrv\appcmd list wp