Keep it Simple and Smart
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.
» Read moreNow 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
» Read moreWhat 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
» Read moreYou 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
» Read moreI 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
» Read moreSQL 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
» Read moreThe 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,
» Read moreThere are very few simple steps to migrate/ transfer the maintenance plan from one SQL Server instance to another. Maintenance Plan is nothing but SSIS package which SQL Server creates and deploys it under MSDB Database. I have created one maintenance plan to for the demonstration; you may migrate/ transfer
» Read moreIf you are facing the access denied error while connecting to Integration Services as shown below : Error detail: Connecting to the Integration Services service on the computer “ComputerName” failed with the following error: “Access is denied.” (shown in given image) Connect the SQL Server Management Studio with “Run as
» Read moreIn the previous post, we have scheduled automatic backup in SQL Server 2012 – Part1. As we have scheduled daily backup of database and backup file will be generated every day. It is a good practice that to delete backup files after a certain period of time as per requirement.
» Read moreVarinder Sandhu is using WP-Gravatar