Microsoft SQL Server 2005 Service Pack 4 Released!

The RTM version of Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download, and includes SQL Server 2005 SP3 cumulative updates 1 to 11, customer requested fixes and the SQL Server 2005 SP4 database engine support for DAC operations.Refer SQL Release Services Team blog


SQL Server Denali – AlwaysON (HADR): Step-by-Setup setup guide

As you might be aware that SQL Server Code-Named “Denali” has introduced a new feature called Always ON for enhancing the availability of user database in a enterprise environment. In simple terms, AlwaysON is a high-availability and disaster recovery solution, which will enable you maximize availability of your critical user databases by use of “availability…


SQL Server 7.0 support to end on 11 Jan 2011

For additional details check the link below: Regards,SQLServerFAQ   

SQL Server 2008 Best Practices Analyzer (SQL BPA) – Video

The SQL Server Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server recommendations and best practices to determine if there are potential issues in the database environment. Presented by: Harsh Chawla, Support Engineer – SQL Support Team.


Unable to connect to SQL , “Error executing extended stored procedure: Invalid Parameter (Microsoft SQL Server, Error: 22001”

Issue   When we try to connect to a SQL instance from SQL server Management studio we get the following error : Error executing extended stored procedure: Invalid Parameter Error executing extended stored procedure: Invalid Parameter (Microsoft SQL Server, Error: 22001)     Environment Windows : Windows Server 2000 Service Pack :SP4 SQL Version: SQL…

RESTORE DATABASE fails while trying to restore password protected backup set from SSMS

ISSUE: I’m trying to restore a database backup from SSSMS-UI, however it fails in an initial stage with below error TITLE: Microsoft SQL Server Management Studio——————————Specified cast is not valid. (SqlManagerUI)—————————— Here’s the detailed error:Program Location: at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.PopulateGridWithBackupSetsFromDevices()at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.GetBackupSetsFromDevices()at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.textDeviceSelected_TextChanged(Object sender, EventArgs e)at System.Windows.Forms.Control.OnTextChanged(EventArgs e)at System.Windows.Forms.TextBoxBase.OnTextChanged(EventArgs e)at System.Windows.Forms.Control.set_Text(String value)at System.Windows.Forms.TextBoxBase.set_Text(String value)at System.Windows.Forms.TextBox.set_Text(String value)at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs…

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…