Originally posted on: http://geekswithblogs.net/AskPaula/archive/2017/08/29/sql-server-how-do-i-get-the-filegroup-data-file.aspx-- start with this:SELECT dbfile.name AS DatabaseFileName, dbf… Read More

SQL Server database consists of two types of filegroups, primary and user-defined. Primary filegroup includes primary files. System tables come under the primary filegroup. User-defined… Read More

Today lots of messages were getting suspended in the production env and to find the exact reason for this sudden messages getting suspended, looked into the Event Log and found below two err… Read More

Introduction:SQL Server has a very important file called Log file, that records all transactions and modifications made in SQL Server data. But when the SQL Server transaction log becomes fu… Read More

SQL Server, DBA interview questionsQuestions are categorized under the following sections, for your convenience:Database design (8 questions)SQL Server architecture (12 questions)Database ad… Read More

You can backup the DB from the server and then restore it on your local machine with installed MS SQL Server 2000. Then you can change or delete any pruned info from the DB on your local ma… Read More