Unable to detach SQL database: "The database is in single-user mode, and a user is currently connected to it."

Scenario:   When you attempt to Detach a SQL database, you may possibly end up encountering an error message as below: C:\>SQLCMD.EXE -U sa -P P@ssword -S TESTDBSRV01\APPDB01 -i “C:\Detach-APP-DB.sql”Msg 5064, Level 16, State 1, Server TESTDBSRV01\APPDB01, Line 1Changes to the state or options of database ‘APPDB01’ cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.Msg 5069, Level 16, State 1, Server TESTDBSRV01\APPDB01, Line 1ALTER DATABASE statement failed. C:\> Where in my C:\Detach-APP-DB.sql file contains below statement: ALTER DATABASE HRINDDB01 SET OFFLINE WITH ROLLBACK IMMEDIATE Solution:   To resolve […]

Read more

Implementing Desktop Theme Look and Feel for XenApp 6.5 Applications on Windows Server 2008 R2

Its is very common requirement for Application Service Providers who host customer applications on their XenApp infrastructure as a cloud solution. It’s very often your customers request you to enable a Windows desktop (in particular Windows 7) theme (look and feel for Window frames). Here are quick steps to achieve this requirement using Citrix Enhanced Desktop Component: Enable Citrix Enhanced Desktop: Citrix Enhanced Desktop is a component which is installed by default with the XenApp Server role installation.  To enable Citrix Enhanced Desktop component for your users manually in case of restricted environments by temporarily disabling the restrictions: login to […]

Read more

Move WordPress Blog from AWS Instance to GoDaddy Managed WordPress Hosting

Here are the steps to move your WordPress blog website setup off from Amazon Web Services (AWS) Windows Server 2012 instance to GoDaddy Managed WordPress hosting.   Amazon Web Services (AWS) Windows Server 2012 instance: Backup your WordPress IIS Web Folder Backup your WordPress MySQL DB using Export to Dump Project Folder (recommended if you have large size tables in your DB, generates .SQL file for each table, using this .SQL file you can recreate the same table on other DBs) Export to Self-Contained File (recommended for small size tables usually for small websites, so that all tables data will […]

Read more