Backup Retention Part 1 Backup Retention Part 3 In part 1 I spoke about why you would want to restore from backups and some other reasons to have an older backup around. In part 2 I will dive more into the specific types of backup retention methods. Part 3 I will define more on methods but also cover combined methods …
I have been doing more and more replication work lately, and when recently testing some replication work I needed to create and drop some test databases and re-test the replication work. After configuring a database for replication, then deleting the publisher and the subscriber I attempted to drop the database and get the following error: Msg 3724, Level 16, State …
Cannot drop the database because it is being used for replication Read more »