Browsing articles from "August, 2013"
Aug
29
2013

Transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds

082913_0956_Transaction5.png

While dealing with a rollback/kill process (in SQL Server 2005 SP4 + CU3 environment) which is stuck for more than 10 days, it was a VERITAS NetBackup (DB tape backup) process,     On checking the DMV’s dm_exec_requests and dm_exec_sessions using below query, SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT db_id(DB_NAME(er.[database_id])) [DBID] ,er.[session_id] AS [SessionID] ,er.[command] AS [CommandType] ,est.[text] [StatementText] ,er.[status] AS [Status] ,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent] ,CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m] […]

Aug
20
2013

SQL Server Installation failed with error status: 1639

082013_1119_SQLServerIn1.png

Today while installing SQL Server 2008 R2 with SP1, installation failed with following error code, —————— MSI (s) (4C:9C) [04:51:32:016]: Product: SQL Server 2008 R2 SP1 Database Engine Services – Update ‘Service Pack 1 for SQL Server Database Services 2008 Core Instance (64-bit) (KB2528583)’ could not be installed. Error code 1639. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130820_043842\sql_engine_core_inst_Cpu64_1.log.   MSI (s) (4C:9C) [04:51:32:016]: Windows Installer installed an update. Product […]

Aug
9
2013

Save time by using Outlook 2010 Email Templates

080913_1135_Savetimebyu1.png

We have some regular activities for which standard emails needs to be sent on regular basis, in order to reduce time in drafting email, there is built-in facility in Outlook to create and use email templates, so we can define the fixed text once and reuse it at regular intervals, below are the guidelines I found for learning this technique, please go through these links to understand how it works and can be utilized,   […]

Aug
4
2013

SQL SERVER 2008 R2 not able to come online – Initializing the FallBack certificate failed

080413_0643_SQLSERVER207.png

While applying a service pack on SQL Server 2008 R2, after server reboot, SQL service were unable to start and following error noted in SQL Error log, ———– Error: 17190, Severity: 16, State: 1. Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788. Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.   Error: 17182, Severity: […]

Subscribe to this blog via Email

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

Join 446 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2013
M T W T F S S
« Jul   Sep »
 1234
567891011
12131415161718
19202122232425
262728293031  

View Post by Categories

%d bloggers like this: