SQL Server - Managing Databases and Physical Files in SQL Server

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Databases and Physical Files in SQL Server. Clear answers are provided with tutorial exercises on creating, renaming, and deleting databases; setting current database; bringing databases offline and online; reviewing, moving and copy database physical files.

What Is a Database in SQL Server

Simplest Way To Create New Databases in SQL Server

"USE" - Setting the Current Database in SQL Server

"DROP DATABASE" - Deleting Databases in SQL Server

Database in Use When Dropping a Database in SQL Server

Getting a List of All Databases on the Server in SQL Server

Location of Database Files in SQL Server

Creating Databases with Specified Physical Files in SQL Server

Renaming Database Names in SQL Server

Database in Use When Renaming a Database in SQL Server

ONLINE/OFFLINE - Database States in SQL Server

OFFLINE - Taking a database offline in SQL Server

Moving Database Physical Files to New Locations in SQL Server

READ_ONLY/READ_WRITE - Database Update Options in SQL Server

SINGLE_USER/MULTI_USER - Database User Access Options in SQL Server

System Databases Used by SQL Servers in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-24, 377👍, 0💬