How do I drop a database in SQL Server 2012?
Using SQL Server Management Studio
- In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
- Expand Databases, right-click the database to delete, and then click Delete.
- Confirm the correct database is selected, and then click OK.
How do I create a distribution database in SQL Server 2014?
Follow the Configure Distribution Wizard to:
- Select a Distributor.
- Specify a root snapshot folder (for a local Distributor).
- Specify the distribution database (for a local Distributor).
- Optionally enable other Publishers to use the Distributor.
- Optionally script configuration settings.
Do you need to drop distribution in SQL Server?
To disable distribution, the distribution database must be online. If a database snapshot exists for the distribution database, it must be dropped before disabling distribution. A database snapshot is a read-only offline copy of a database, and is not related to a replication snapshot. For more information, see Database Snapshots (SQL Server).
What does SP _ dropdistributiondb do in Transact SQL?
sp_dropdistributiondb (Transact-SQL) Drops a distribution database. Drops the physical files used by the database if they are not used by another database. This stored procedure is executed at the Distributor on any database.
When to disable publishing and distribution in SQL Server?
If any database snapshots exist for distribution or publication databases, they must be dropped before disabling publishing and distribution. A database snapshot is a read-only offline copy of a database and is not related to a replication snapshot.
How to delete distribution database in SQL Server?
At the Distributor, execute sp_dropdistributiondb to delete the distribution database. This stored procedure should be run once for each distribution database at the Distributor. This also removes any Queue Reader Agent jobs associated with the distribution database.