Feb
15
2013

The command failed because the database mirror is busy. Reissue the command later.

Issue: Trying to turn of database mirroring, disconnected mirroring from Principal database but when checked the partner Database, found that database still in restoring mode, when trying to delete it, it failed stating database is part of mirroring as below,     Then ran following command/s which resulted in error, ALTER DATABASE [STASxref] SET PARTNER OFF; ALTER DATABASE [STASxref] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;   Msg 1404, Level 16, State 11, Line 1 The command failed because […]

Feb
15
2013

Microsoft SQL Server on Private Cloud

While trying to identify a solution for an internal private cloud for a client and deploy SQL Server as a service on it, came across following articles which can provide some useful insight and references,   Microsoft provides certain case studies and articles at following link on private cloud, http://www.microsoft.com/en-us/sqlserver/solutions-technologies/hybrid-it/private-cloud.aspx   Microsoft with HP and Dell has provided Database consolidation and private cloud appliances as well, details at following link, http://www.microsoft.com/sqlserver/en/us/solutions-technologies/Appliances/HP-dca.aspx http://h71028.www7.hp.com/enterprise/us/en/partners/microsoft-database-consolidation-solution.html http://blogs.technet.com/b/dataplatforminsider/archive/2011/10/13/announcing-the-first-database-consolidation-amp-private-cloud-appliance.aspx   If […]

Feb
15
2013

Virtualizing Microsoft SQL on VMware vSphere

Useful resources for virtualizing your SQL Servers on VMWare ESX   http://www.vmware.com/solutions/business-critical-apps/sql-virtualization/microsoft-support.html   DBA Guide to Databases on VMware – White Paper Availability and Recovery Options for Microsoft SQL® on vSphere Best Practices Guide for Virtualizing SQL Server SQL Server on vSphere FAQ Support and Licensing Guide – SQL Server on vSphere SQL Server on vSphere – Use Cases VMware Performance Benchmarks and Resources Reference Architecture: EMC Business Continuity for SQL Server 2008 Reference Architecture: […]

Feb
11
2013

The log cannot be rebuilt because the database was not clearly shutdown (Microsoft SQL Server, Error: 945)

Today found that soemone has delete log file of one of database and database was inaccessible, when tried to take it offline and then bring online received following error while bringing it online,   “Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details”   “The log cannot be rebuilt because the database was not clearly shutdown (Microsoft SQL Server, Error: 945)”     […]

Feb
7
2013

Symantec Veritas Netbackup Useful References

Some useful references which comes handy while configuring, fixing, troubleshooting problems related to NetBackup ,   How to Backup and Restore Microsoft SQL Server Backup via Netbackup –By Zahid Haseeb   A comprehensive list of solutions for the most common NetBackup for Microsoft SQL Server database agent backup and restore issues –By Symantec Team   Setup NetBackup to send Emails – by Mariam Kupatadze   –Will keep the list updated as and find some new […]

Jan
31
2013

How to transfer logins and passwords between instances of SQL Server 2008

How to transfer logins and passwords between instances of SQL Server 2008How to transfer logins and passwords between instances of SQL Server 2008 1. On server A, start SQL Server Management Studio, and then connect to the instance of SQL Server from which you moved the database. 2. Open a new Query Editor window, and then run the following script.

3. Note This script creates two stored procedures in the master database. The procedures […]

Jan
29
2013

dbc_RemoteWriteFile: ERR – could not write progress status message to the NAME socket

In continuation with my old post where I troubleshoot the Symantec NetBackup Error (31073), today faced similar error on another server where UAC was enabled earlier but disabled later. On investigation found Error (31073) again but this time even after implementing all solutions from my last post link, faced a new error as below, Error: In GUI console, ERR – Error in CreateEx: 0x80070005. CONTINUATION: – Unknown VDI error code In dbclient, 06:24:13.321 [1628.6700] <2> […]

Jan
29
2013

Lock Pages in Memory enabled but “Using locked pages for buffer pool” message not found

On a SQL Server 2005 x64 SP4+CU3 Standard Edition with Lock pages in memory settings enabled, max memory configured, found issue that “Using locked pages for buffer pool” message is not logged in SQL Server Error logs,   How to check Lock Pages in Memory is enabled? Run below commands in SSMS and in result you should see message like “Using locked pages for buffer pool” else configure or troubleshoot based on situation, exec xp_readerrorlog […]

Jan
28
2013

Memory Supported by the Editions of SQL Server

SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms143685(v=sql.90).aspx SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms143685(v=sql.100).aspx SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms143685(v=sql.105).aspx

Jan
16
2013

Using Concatenate function in excel without impacting custom format

Suppose you have date time text in one column (format as YYYY-MM-DD) which you want to use in your concatenate function without changing custom format, because if you don’t do it then in concatenate function it will come in some numerical form for e.g. 40513 instead of 2010-12-01. It happens because excel ignores formatting.   Use below to fix it, Say column name is A1 where date value resides and you want to sue it […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: