April, 2010

As part of Encryption Key management in SQL Server 2008 Transparent Data Encryption (TDE) implementation, SQL server allows re-encryption of a mirrored database without breaking the Mirroring setup. In the following post I would be describing the script...

Problem: SQL Server Agent cannot start because the instance of the Server Instance is not the expected Instance The SQL Server Agent may fail to start after a restart of the SQL Services. You may see this issue when you have multiple SQL Server...

1. Can I use SQL 2008 slipstreamed installer to install SQL Server 2008 failover cluster? Yes. Launch the setup.exe from command prompt with PCUSource = <path to extracted SP1>. Refer http://blogs.msdn.com/petersad/archive/2009/03/02/sql-server...

Issue : The Service Pack 1 installation on SQL Server 2008 fails with the following errors : detail.txt: Instance INST01 overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason...

· Disclaimer : Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office...

Problem Description: ================ You may notice that when you configure logshipping in SQL server 2005 from primary server, it gets configured successfully without any error but no logshipping job is created on primary server. Also logshipping...

Thanks for overwhelming response of part 1 of the series. As a part of this series, we have created a Domain Controller (Win2k8MyDC). Let’s go ahead and follow the steps below to add two more machines into my domain (blakhani.com). For this you need two...

Consider a scenario where we have set up a transactional replication between two servers and you want to MOVE the publication database and Distribution database to a different location.  The procedure for moving the system database ‘Distribution...

It’s a very common scenario where customers have their database encrypted and hold multiple certificates on their SQL Server environment. In this blog I would be sharing some good information on steps to restore full backup that was taken at the time...

Network Binding Order Rule Warning in SQL Server 2008 Cluster Setup Explained This blog present some more information about the “network binding order” setup rule that is present in SQL Server 2008. We have another blog that talks about the issues...

Here is a scenario where you might end up receiving a Fatal Error while installing SQL 2005 on Windows 2008 environments. Below is the snippet from the Setup logs: Summary Log: ========== OS Version : Server 4.0, Enterprise Edition Service...

Problem Description =============== · After role reversal in a log shipping setup, the stored procedure sp_help_log_shipping_monitor may return the following error OR we may find the error in the log shipping report in SQL Server Management Studio...

(How to uninstall SQL Server 2005 Cluster / How to break SQL Server 2005 Cluster ) There will be situations where you want to perform any of below task: 1.        Convert two node SQL cluster to standalone instance of SQL...

Problem Description ======================================= We encountered a situation where we were trying to execute a maintenance plan to rebuild the index of OperationsManagerDW database. However, the maintenance plan fails to complete. ...

Symptoms. ======== You are unable to connect to SQL Server immediately after applying Service Pack or any Cumulative updates. You will see the SQL Server in Started status for few seconds and then it would stop. On a cluster environment you...

If you have migrated your Database\Instance or if the drive holding the SQLdata has been decommissioned, then in those scenarios how do you move the SQL Full-text Filter Daemon Service Error Log (FDLAUNCHERRORLOG) from one location to another in SQL 2008...

Recently I came across an issue wherein you are installing SQL Server 2005 on an n-node Windows cluster. The setup keeps on failing with the following error message on GUI screen: --------------------------- Visual Studio Just-In-Time Debugger...

SYMPTOM ======= · When you try to create a login using the command "Create login [<Domain>\<Machine account>$] from windows" we might get the following error o Msg 15025, Level 16, State 2, Line 1 o The server principal '<DOMAIN...