[toc] Query-1: SQL Server log file growing unexpectedly? “We are wondering why transaction logs keep on increasing?? It become so gigantic, the transaction log size… Read More »Foolproof Tips for Reading and Shrinking Transaction logs in SQL Server
I am SQL DBA and SQL Server blogger too. I like to share about SQL Server and the problems related to it as well as their solution and also I do handle database related user queries, server or database maintenance, database management etc.
[toc] Problem: A few days ago, while migrating data from one database to another, I encountered an interesting problem which user faced a lot. “I… Read More »How to Copy Table Schema and Data from One Database to another Database in SQL Server
[toc] Introduction Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational database management system (RDMS) consisting… Read More »SQL Log File Corruption and Possible Recovery Methods
[toc] To get a damaged MDF file is not rare. However, the main cause behind it is that the file is prone to corruption. When… Read More »Learn to Repair Corrupt MDF File with Perfection
You must have thought how to store data in SQL Server? SQL Server is the platform, which provides a proper management of database. There is… Read More »Understand the Internal Structure of SQL Database File