Jul 172014
 

What is Log Shipping? Log Shipping is a basic level SQL Server high-availability technology. It is automated process to send the transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. How Log Shipping Read More

Jul 102014
 

Error Messages : This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools) Cause  : The database to which you are connected does not allow schema modification with the Visual Database Tools. Resolution : Be sure you are connected to the correct database or Use the correct version SQL Server Management tool.

Jun 302014
 

Many times we face a requirement to perform the unattended installation of SQL Server. In this post we will see the steps to perform the unattended installation of SQL Server 2012 using command line. There are two ways to install the unattended installation of SQL Server 2012 using command line. Specify each required parameter , you may take the parameter Read More

May 272014
 

Introduction Microsoft introduced the AlwaysOn Availability Groups which is a high-availability and disaster-recovery solution that provides an enterprise-level solution in SQL Server 2012. Using Database Mirroring for local high availability and combining it with Log Shipping for a disaster recovery solution is popular deployment architecture prior to SQL Server 2012. With SQL Server 2012, the Database Mirroring and Log Shipping Read More

May 212014
 

Now here we have question regarding the Mirroring Database: How can we recover the data from mirror database? How to restore the mirroring database? Here I would like to clear that we cannot restore a database that is involved in Mirroring without removing Mirroring. Removing the Mirroring using T-SQL ALTER DATABASE MirrorTest SET PARTNER OFF; Restore the Mirror Database RESTORE Read More

May 202014
 

What is Database Mirroring? Database mirroring is a solution for increasing the availability of a SQL Server database. But it has been gained popularity as a disaster-recovery option. How Database Mirroring Working. The principle server sends the active transaction log record to the mirrored server. The mirrored server applies the transaction log record one by one in sequence. Prerequisites The Read More

May 132014
 

After your installation of CollabNet Subversion Edge, once you will create user that gets the Read-Write Access to all the available repositories because by default Repository Access Rule is (as shown below) [/] * = rw That means Read-Write Access to all Users for all available repositories. You should Edit Repository Access Rule as [/]* = r varinder = rw Read More

May 122014
 

In the previous post, you have seen the complete installation of Subversion Edge. After Installation, once you will login the web-based console for configuration managing the server. You can see in the below screenshot, Your SVN Server is down yet. Now, first we see some important configuration parameter (Highlighted in Red) that we have to set as per our requirement Read More

May 122014
 

CollabNet Subversion Edge is a Subversion server distribution that includes a complete software stack of Apache, Subversion and ViewVC as well as a powerful web-based console for managing the server. In this Post, we will see the intallation steps for CollabNet Subversion Edge. Go to URL : http://www.collab.net/downloads/subversion  and download latest version Subversion Edge and within minutes be up and Read More

May 062014
 

Packt Publishing firmly believes that you should be able to read and interact with your content when you want, where you want, and how you want – to that end they have been advocates of DRM-free content since their very first eBook was published back in 2004. To show their continuing support for Day Against DRM, Packt Publishing is offering Read More

Apr 252014
 

You will get the step by step tutorial to install the SQL Server with Full or Partial features. Many time people are looking specific feature that we need to install for Reporting service Native Mode Report Server. So the purpose if this post is give idea of feature required for SQL Server Reporting Service Installation as shown in given snapshot:

Mar 252014
 

I pleased to announce that Reporting with Microsoft SQL Server 2012 has been published. Officially, I have reviewed this book. I would like to request you all to read this book and provide your valuable feedback on the content. Click here for more detail about Reporting with Microsoft SQL Server 2012

Mar 212014
 

SQL Server supports the two authentication mode as Windows authentication mode and Mixed authentication mode. Once the user is authenticated, SQL server will allow access to the user based on the permission that user has. All the user permissions are based on Server Role and Database Role. So let try to user understand the meaning of each server role and Read More

Mar 182014
 

Known for their extensive range of pragmatic IT ebooks, Packt Publishing are celebrating their 2000th book title `Learning Dart’– they want their customers to celebrate too. To mark this milestone Packt Publishing will launch a ‘Buy One Get One Free’ offer across all eBooks on March 18th – for a limited period only. `Learning Dart’ was selected as a title Read More

Mar 072014
 

The msdb database is system database used by SQL Server Agent for scheduling alerts and jobs. msdb.dbo.backupset – Contain the information concerning the most-granular details of the backup process msdb.dbo.backupmediafamily – Contains the metadata for the physical backup files as they relate to backup sets Using the above mentioned tables, we will find the backup history of database Script: SELECT Read More