Category: MSSQL

18 Nov by dbtut

How To Find Last Backup Dates Of SQL Server Databases

  With the help of the following script, you can find the date of the last backup of each database on that instance. ‘L’ indicates Log Backup. If you type ‘D’ in this section, you can see the last full backup date, if you type ‘G’, you can see the latest differential backup date. If […]
15 Nov by dbtut

How To Change SQL Instance/Server Name

  Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test and you have an instance named testinstance on your test server. You can normally connect to Instance as “test\testinstance”. Suppose that the name of the test server is changed […]
13 Nov by dbtut

How To Read SQL Server Audit

  You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit. You can read an audit via SSMS with the help of the following script. [crayon-5bf19179bb978809000442/]   We read our audit “AuditFileName.sqlaudit” under “C:\Audit” path  in our script. You must write the path of […]
12 Nov by dbtut

How To Create SQL Server Audit

  We need to create an Audit to record transactions made by people and dbas in SQL Server. In this article, we will examine the process of creating an audit. We can define two types of audit.   Database Level Audit: First, right-click Audits in the Security section of SSMS and click on the new […]
11 Nov by dbtut

Difference Between Always On Failover Cluster, Database Mirroring, Always On Availability Group, Replication and Log Shipping

  I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR (Disaster Recovery). Briefly, we will compare the technologies listed below. Always On Failover Cluster Database Mirroring Always ON Availability Group Replication Log Shipping   Always On Failover Cluster: You […]
10 Nov by dbtut

Collecting Environment Information

  You can use the following script to collect the enviroment information that are set on the user you are connecting to the database. This allows you to access all values assigned to the user. [crayon-5bf19179bbb59959735293/]
10 Nov by dbtut

What is Database Snapshot On SQL Server

  Database Snapshot is the creation of an unchangeable image of the database, you can think of it as taking current photo of database. If I explain it through an example it will be clearer.   For example, we take the snapshot of the AdventureWorks2014 database. We are reading through this snapshot. No changes have […]