Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ?

The Remote Procedure Call (RPC) [http://support.microsoft.com/kb/832017] system service is an interprocess communication (IPC) mechanism that enables data… Read more

1 comments, 53 reads

Posted in MSSQLFUN on 22 December 2014

SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.

Steps I perform to resolve the issue, Seems to be a WMI error :-

1) If using Window Server 2008 & above, Run command from command prompt… Read more

0 comments, 97 reads

Posted in MSSQLFUN on 9 December 2014

SQL Server 20082008 R22012 || Remove Node from failover cluster

Steps to remove node from failover cluster for SQL Server 2008 onwards :-

Note :-

a) Same process will be used to remove node from failover cluster

b) Same process will be used when you left with only one node, this will clear cluster group as well

c) Old process… Read more

0 comments, 141 reads

Posted in MSSQLFUN on 2 December 2014

TempDB Configuration Best Practices

1. Do not change collation of TempDB from the SQL Server instance collation.

2. Do not change the TempDB database owner from sa.

3. Do not drop the TempDB database.

4. Do not drop or revoke the guest user from the database.

5. Do not change the recovery model from… Read more

0 comments, 272 reads

Posted in MSSQLFUN on 24 November 2014

Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !

The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 110 reads

Posted in MSSQLFUN on 24 November 2014

Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can plan… Read more

0 comments, 120 reads

Posted in MSSQLFUN on 24 November 2014

Interview Questions on SQL Server Database Mirroring

1) What is default port of Database Mirroring Endpoint?

Ans : 5022

2) Database Mirroring comes with which edition?

Ans: SQL Server 2005 SP1. Or SQL Server 2005 RTM with trace flag 1400

3) When I configure mirroring I’m receiving the below errror,
One or more of the server network… Read more

0 comments, 362 reads

Posted in MSSQLFUN on 17 November 2014

Script to Monitor SQL Server Database Mirroring Status

SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database Mirroring send logs to mirror from principle. We need to monitor Database Mirroring status continuously to ensure that everything is working fine. We can use MSDB.SYS.SP_DBMMONITORRESULTS system store procedure to… Read more

2 comments, 128 reads

Posted in MSSQLFUN on 13 November 2014

Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2. Click Configure Security, Configure Database Mirroring Security Wizard welcome screen appears, click Next.

3. In the Include Witness Server dialog box, click Yes, and then click Next.

4.… Read more

2 comments, 164 reads

Posted in MSSQLFUN on 10 November 2014

SQL Server Database Mirroring Monitoring

SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working fine.

We are monitor Database Mirroring by 2 ways :-

1) SSMS : Connect to Principle Server > Select Database >… Read more

2 comments, 132 reads

Posted in MSSQLFUN on 3 November 2014

Add Database File on Database invloved in DB Mirroring

Originally posted on MSSQLFUN:

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.

Steps to Add Database File on Database involved in DB Mirroring…

Read more

1 comments, 146 reads

Posted in MSSQLFUN on 29 October 2014

Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !

The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

Those who are facing severe issues with their environment, they can plan to test… Read more

0 comments, 144 reads

Posted in MSSQLFUN on 27 October 2014

Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2) To remove the witness, delete its server network address from the Witness field.

3) Click Ok to confirm.

You can also perform the same action by below T-SQL. Read more

1 comments, 5,109 reads

Posted in MSSQLFUN on 27 October 2014

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.

Steps to Add Database File on Database involved in DB Mirroring :-

1) Break the Mirroring Read more

2 comments, 5,090 reads

Posted in MSSQLFUN on 20 October 2014

Database Mirroring States (SQL Server)

SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :-

Mirroring state Description
SYNCHRONIZING The contents of the mirror database are lagging behind the contents of the principal database. The principal server is sending log records to the mirror server, which is applying the changes…

Read more

1 comments, 355 reads

Posted in MSSQLFUN on 14 October 2014

Configure SQL Server Database Mirroring

1) Take Full backup of database at Principle Server

BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’

2) Take Log Backup at Principle Server

BACKUP LOG USERDB1 TO DISK = ‘H:USERDB1_LOG.TRN’

3) Copy both backup files to Mirror server

4) Restore Full backup with No Recovery at Mirror Server

USE [master] Read more

2 comments, 5,855 reads

Posted in MSSQLFUN on 13 October 2014

Does Full Backup contain data inserted during backup ?

Question : When you take full backup, do it capture data till the time backup start time or till the time backup end.

Answer : Full backup capture database till the backup completion time. Let check it :-

1) I have initiated the TEST database backup with buffercount =1 so… Read more

0 comments, 171 reads

Posted in MSSQLFUN on 6 October 2014

SQL Server 2008 Service Pack 4 Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download at the Microsoft Support site. SQL Server 2008 Service Pack 4 contains all the hotfixes released since the initial release of SQL Server 2008 RTM.

I suggest to test SQL… Read more

0 comments, 170 reads

Posted in MSSQLFUN on 2 October 2014

SQL Server 2008 R2 Service Pack 3 Is Now Available !

Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008 R2 Service Pack 3 contains all the hotfixes released since the initial release of SQL Server 2008 R2 RTM.

I suggest… Read more

0 comments, 183 reads

Posted in MSSQLFUN on 29 September 2014

Older posts