Troubleshoot slow-running queries - SQL Server | Microsoft Learn
Jan 10, 2025 · This article describes how to handle a performance issue that database applications may experience when using SQL Server: slow performance of a specific query or group of queries. The …
Create a Full Database Backup - SQL Server | Microsoft Learn
Aug 26, 2025 · Learn how to create a full database backup in SQL Server by using SQL Server Management Studio, Transact-SQL, or PowerShell.
Back up and Restore of SQL Server Databases - SQL Server
Dec 5, 2025 · This article describes the benefits of backing up SQL Server databases and introduces backup and restore strategies and security considerations.
Intermittent or periodic issues with connecting to SQL Server - SQL ...
Feb 12, 2025 · The SQL Server ERRORLOG file may show IO operations taking longer than 15 seconds, which is another indicator of performance issues. In the network trace, you might also see …
Backup Database in MS SQL Server - GeeksforGeeks
Jul 15, 2025 · In Microsoft SQL Server, we can create full database backups using either SQL Server Management Studio (SSMS) or Transact-SQL (T-SQL). In this guide, we will learn an overview of the …
Set a database to single-user mode - SQL Server
Jul 22, 2024 · Applies to: SQL Server This article describes how to set a user-defined database to single-user mode in SQL Server by using SQL Server Management Studio or Transact-SQL. Single …
How to Identify Slow Running Queries in SQL Server?
Jul 23, 2025 · Utilize SQL Server Profiler or Extended Events to capture and analyze slow-running queries in real-time. These tools help track query performance and diagnose issues by providing …
Monitor Memory Usage - SQL Server | Microsoft Learn
Sep 2, 2025 · Monitor a SQL Server instance to confirm that memory usage is within typical ranges. Use the Memory: Available Bytes and Memory: Pages/sec counters.
Restore the master Database (Transact-SQL) - SQL Server
Apr 17, 2025 · This article shows you how to restore the master database in SQL Server from a full database backup by using Transact-SQL.
sql - Why is my LDF file taking up so much space, and how can I free …
Nov 26, 2025 · Why is the log file taking this much space (30gb)? It was because the Autogrowth / Maxsize was set to 200,000 MB. How can I free up the space? As described I used the following …