Can you explain what would be the replication overhead on production server? The ConfigurationFile.ini file is a text file which contains the set of parameters in name/value pairs along with descriptive comments. What is shared storage in SQL server cluster? Can SQL Server Instance be up without TempDB? Ans: SQL Server Error Log: The Error Log, the most important log file, is used to troubleshoot system problems. SQL Server detects deadlocks and terminates one user’s process. How would you move data or log file of a Database from one drive to another? We have number of products in market. NET 3.5 SP1 is a requirement for SQL Server 2012 when you select Database Engine, Reporting Services, Replication, Master Data Services, Data Quality Services, or SQL Server Management Studio, and it is no longer installed by SQL Server Setup.
I have been thinking since long time to pen down a comprehensive series on most commonly asked DBA Interview questions. What are major differences between SQL Server 2005 and SQL Server 2008 version? How to use SQL Server Encryption to Secure data? These are installed in the folder
If you have to deploy 20 SSIS Package to SQL Server Integration Services, How would you do that?
What is the difference Between Index Rebuild and Index Reorganize? So the current owner is the active node and other nodes are passive. What is orphan replication? SQL server lost connection with AD, what will happen to SQL Server?
If you need to Backup and Restore Column Encrypted Database, What steps has to be performed? What are the steps to enable TDE on database? What is default Isolation level set for SQL Server Instance? What is Latch? How would you deploy SSAS Cube to SQL Server Analysis Services Server? Why Shrink file/ Shrink DB/ Auto Shrink is really bad? Why do we use Listener in Availability Group? How would you deploy SSRS report to Report Server? How would you script all SQL Server Agent Jobs? Modify the value to the number of logs that you want to maintain. Open SQL Server Management Studio and then connect to SQL Server Instance.
9. You have a clever yet attractive way of writing on Msbi online trainingMsbi online training HyderabadMsbi online training IndiaMsbi online courseMsbi courseMsbi trainingMsbi certification training, Common Interview Questions and Answers for SQL Server DBA, Real Time Interview Questions with Answers for SQL Server DBA, Top 100 Interview Questions for SQL Server DBA, SQL Server Database Administration interview questions with answers, Fresher and Experienced SQL Server DBA Interview Questions, Top 10 SQL Server DBA Interview Questions and Answers, SQL Server - Interview Questions and Answers, Top 5 Interview Questions for Microsoft SQL Server DBA, MySQL / MariaDB Developer Tutorial Beginner to Advance, SQL Server High Availability on Azure Tutorial, Team Foundation Server 2013 Video Tutorial, Team Foundation Server 2015 Video Tutorial, Windows Server 2012 R2 Installation Videos. Ans: Replication is a feature in SQL Server that helps us publish database objects and data and copy (replicate) it to one or more destinations. How would you find blocked processes in SQL Server? How would you find out when SQL Server was restarted last time?
How would you find out how many transactions/second SQL Server Instance is performing? What are some of the questions we could ask to host a quality technical interview to assess a candidate? DES is a relatively old and weaker algorithm than AES. Once the downtime window is started, take a full backup of the user databases and system databases including the Resource database. What is the common trace flags used with SQL Server? Can we uninstall/rollback service packs from SQL Server 2005? Every time a new record is inserted, stamp it with the DayTime, and also stamp it with the date-time when updated. To view the Windows Event log, go to Administrative Tools, Event Viewer. It is a database of a European Bank. Can we take the backup for Resource DB?
All the sudden, users start complaining that the SQL Server is running slow.