Collections:
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, 716👍, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...