There can be certain scenarios when one needs to connect to an SQL Server Instance in a Single User Mode by using the Startup Option -m. For example, the need could be to recover a damaged system database such as Master, Model, MSDB etc or you may want to change the server configuration options. In this article we will take a look at steps which one needs to follow to Start SQL Server in Single User Mode.
SQL Server Database Engine defines the size of virtual log files dynamically while creating or extending transactional log files in SQL Server. Virtual log files will not have a fixed size and one cannot predict the number of VLFs within the transactional log file. Internally, SQL Server will always try to maintain a smaller number of VLFs. However, there is no way for a database administrator to configure or set a fixed size for VLFs in SQL Server.
SQL Server Database Engine supports different startup options for SQL Server Database Engine Service. A database administrator can set the startup options very easily using SQL Server Configuration Manager. In this article we will explore startup options available in SQL Server Database Engine in detail.
How to Start SQL Server without TempDB Database or How to Start SQL Server with Minimal Configuration
This article demonstrates the steps that one needs to follow to start SQL Server without TempDB database or with minimal configuration.
There are often times when as a DBA you need to quickly retrieve SQL Server Configuration Details for a SQL Server Instance. In this article we will explore different ways to retrieve SQL Server configuration details using TSQL queries.
In this article we will take a look at the steps which you can follow to quickly identify the user who deleted the user database in SQL Server.
In this tip we will take a look at how to identify and fix sudden surge of transaction log file especially when a database is configured for Snapshot Replication.
List of SQL Server Replication Articles and Tips which can help DBAs and Developers.
In this tip we will take a look at different ways to find the location of default trace file in SQL Server and how to enable or disable default trace file in SQL Server.
This article demonstrates how to enable an index in SQL Server. It is a very useful feature which will help you enable an index which was disabled earlier to check whether the index was really useful or not without actually dropping the index.
Disabling an Index in SQL Server is a very useful feature which will help you identify whether the index is really useful or not without actually dropping the index.
Microsoft has announced that the SQL Server 2014 Developer Edition will available for free to Visual Studio Dev Essentials members. This article explains how to register and then download SQL Server 2014 Developer Edition for FREE.
This article explains why it is important to leave AUTO CLOSE database option turned OFF for a Production or a Non Production SQL Server Database across all versions and editions of SQL Server.
This article outlines some of the major database backup and restore enhancements which is available in SQL Server 2014.
This tip demonstrates how to use System Configuration Checker Tool (SCC) to identify potential issues which one can encounter before even installing SQL Server on any new or existing server.
|Trending SQL Server Tips|