DBA KNOWLEDGE SHARING
Journey with Databases..
Thursday, 17 May 2018
Unable to Create Restore Plan Due to Break in the LSN Chain
›
Sometimes when you restore your database backup you can get: “Unable to Create Restore Plan Due to Break in the LSN Chain” error.: L...
Thursday, 19 May 2016
Resource Governor
›
Resource Governor is a new technology in SQL Server 2008 that enables you to manage SQL Server workload and resources by specifying limits...
Friday, 16 October 2015
Full backup and Copy-only full backup difference?
›
When you have a full backup and a set of log file backups, a log chain is maintained using the LSN (Log Sequence Number). If you want to d...
Wednesday, 9 September 2015
max worker threads option
›
Purpose of max worker threads option: Thread pooling helps optimize performance when large numbers of clients are connected to the se...
Monday, 31 August 2015
Different Windows credential in SSMS
›
Connecting SQL Database with Different Windows credential in SQL Server Management Studio (SSMS) 1. Just open the command prompt (Star...
Saturday, 27 June 2015
Interview Questions Answers – Clustering
›
1) What is Windows Cluster? Clustering can be best described as a technology that automatically allows one physical server to take ove...
›
Home
View web version
