Tag: SQL Server

Categories
Sql Server

How To Hide An Instance Of SQL Server

How To Hide An Instance Of SQL Server In this article we will learn How To Hide An Instance Of SQL Server. Sometime in your organization you has been asked for hiding an Instance of SQL Server. In earlier post we have dicussed How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE. Hiding an SQL Server Instance will help […]

Categories
Sql Server

SQL Server Interview Questions & Answers 2

SQL Server Interview Questions & Answers 2 Question 6: How is a point in time recovery performed independent of a server down situation? Ans. It depends on which backup types are issued.  In this example let’s assume that full, differential and transaction log backups are issued. 1. Restore the most recent full backup with the NORECOVERY […]