SQL Server Backup Simulator

We at SQL Server support team, continue to invest our time in writing tools and utilities which can aid you in troubleshooting SQL Server issues. SQL Server Backup Simulator is one such tool which will help you while troubleshooting issues in taking backup of SQL Server using 3rd party utilities like IBM Tivoli, Symantec BackupExec,…


SQL Server 2008 service fails to start, after applying Service Pack 1

Recently, I worked on an interesting case where customer after upgrading an instance of SQL Server 2008 with SP1, the SQL server 2008 services and resources went into a stopped and failed state respectively. The services might appear to come online briefly for few seconds but will fail eventually. Let me share more about it…


Troubleshooting tempdb growth due to Version Store usage

Troubleshooting tempdb growth due to Version Store usage   Recently I worked on an issue where the tempdb database version store cleanup was not occurring. I created a small repro to demonstrate the behavior. My tempdb has been showing the version store usage below for the past 3 days: sys.dm_db_file_space_used   runtime                         version_store_kb     2010-10-08 10:28:52.740…