Managing Databases and Physical Files in SQL Server
Where to find answers to frequently asked questions on Managing Databases and Physical Files in SQL Server?
✍: FYIcenter.com
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
2016-11-24, 476👍, 0💬
Related Topics:
