creativeloading.blogg.se - Cara sql server

You have to remove it, if your database is involved in the log shipping.

You cannot delete the database that is involved in the log shipping.

Limitation: You cannot delete the System database file. When user drop the SQL Server database, then it cannot be retrieved without the backup. The query is user want to delete a SQL Server database when data is no longer required or data moved to another server or database. The blog discusses how to delete SQL Server Database by using SQL Server Management Studio and Transact-SQL. Stacy Brown | December 9th, 2015 | SQL Transaction Log | Introduction