What Is The Difference Between Dropping A Database And Taking A Datab

1.	What Is The Difference Between Dropping A Database And Taking A Database Offline?
Answer» Drop DATABASE DELETES the database along with the physical files, it is not possible to bring back the database unless you have a backup of the database. When you take a database OFFLINE, you the database is not available for USERS, it is not deleted physically, it can be BROUGHT back online. Drop database deletes the database along with the physical files, it is not possible to bring back the database unless you have a backup of the database. When you take a database offline, you the database is not available for users, it is not deleted physically, it can be brought back online.

What Is The Difference Between Dropping A Database And Taking A Database Offline?

Answer»

Drop DATABASE DELETES the database along with the physical files, it is not possible to bring back the database unless you have a backup of the database. When you take a database OFFLINE, you the database is not available for USERS, it is not deleted physically, it can be BROUGHT back online.

Drop database deletes the database along with the physical files, it is not possible to bring back the database unless you have a backup of the database. When you take a database offline, you the database is not available for users, it is not deleted physically, it can be brought back online.

Discussion

No Comment Found

Related InterviewSolutions

What Is The Difference Between The 2 Operating Modes Of Database Mirroring?
What Are The Operating Modes In Which Database Mirroring Runs?
Does Transparent Data Encryption Provide Encryption When Transmitting Data Across Network?
What Is Transparent Data Encryption?
What Are The Different Types Of Upgrades That Can Be Performed In Sql Server?
What Are The Different Types Of Database Compression Introduced In Sql Server 2008?
Which Autogrowth Database Setting Is Good?
What Is The Difference Between Dropping A Database And Taking A Database Offline?
When Setting Replication, Is It Possible To Have A Publisher As 64 Bit Sql Server And Distributor Or Subscribers As A 32 Bit Sql Server.
When Setting Replication, Can You Have Distributor On Sql Server 2005, Publisher On Sql Server 2008?