Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cleanup after Deleting a Database
- Thread starter behbeh
- Start date
tlbroadbent
MIS
Generally, SQL Server takes care of most the cleanup. You should check in the database files directory to make sure the MDF, LDF and NDF (if any) files were deleted. SQL Server cleans out entries in backup and restore history tables. You will have to manually delete any DTS packages or Jobs that run against the deleted database. References to the database or its objects in other databases must also be manually deleted - i.e., a view that references a tbale in the deleted DB. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question