Browsing articles from "January, 2013"
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 […]

Jan
15
2013

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

Found SQL Server 2005 SP4 CU3 A/P failover cluster SQL services are stopping and starting several times in interval of 30mins to 1 hour. Following errors are found,   Application Log Errors: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] OnlineThread: QP is not online. [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] […]

Jan
14
2013

Delete Blank rows from long list in excel

To quickly remove unwanted blank rows from long list in excel, do following, Select column having blank rows Press the F5 key on your keyboard (or select Edit, Goto). Click the Special… button. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected. Now right click and choose delete or choose Edit, Delete, select the Entire Row option and click OK.   Useful references: http://chandoo.org/wp/2010/01/26/delete-blank-rows-excel/ […]

Jan
14
2013

How to drop Publisher database in Transactional Replication

Dropping publisher database may be required in various scenarios; please find steps which can help you to drop in case you are facing issues with it. I am including roll back approach as well, it helps sometimes.   First step -> Drop Publication and subscription Second Step -> Drop Database   First step, Right click Publication > Generate Scripts > Generate Drop replication and objects script > Save script to local drive Right click Publication […]

Jan
14
2013

Restore Publisher Database which is part of Transactional Replication

Today I have to restore a publisher database from production backup in QA environment which is part of transactional replication in SQL Server 2005, now there are multiple ways to do it, visit this link for Microsoft recommendation. My approach was, Stop and remove replication, restore database, recreate replication without reinitializing   Before beginning ensure that there is no pending distributed items by going to replication monitor > publication > double click the subscription > […]

Jan
14
2013

Copy folder along with security parameters (ACL) using Robocopy utility

Robocopy is very useful Microsoft provided utility and it comes preinstalled in SQL Server 2008 onwards and can be installed via rktools.exe toolkit in Windows Server 2003 (link)   You can check if Robocopy is installed or not via opening command prompt as, Run>CMD> <type Robocopy /?> If it shows parameter list then Robocopy is installed on your system else download and install (if you are not allowed to install anything on your server, then […]

Pages:12»

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

January 2013
M T W T F S S
« Dec   Feb »
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: