-->
SQL Clone
SQLServerCentral is supported by Redgate
 
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.

Archives: October 2014

Add Database File on Database invloved in DB Mirroring

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 :-

1) Break the…

Read more

1 comments, 531 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, 638 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, 6,323 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,600 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, 1,473 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, 14,253 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, 542 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, 583 reads

Posted in MSSQLFUN on 2 October 2014