I am using Windows Server 2003 r2, MSSQL Server 2005, sp 3.
I have a copy of my production database that I use for testing, called play. I want to delete the play database and make a new copy of my production database, but when I try to delete the play copy, it says I can't because it is currently being used for replication.
Replication was at one point (sort of) set up on the production database (never functional), but never the play database.
I need to get an updated copy of the play database available, with the same name as what the current one is, soon for some important testing.
I have a feeling I'm missing something simple... Any suggestions would be most appreciated. Thanks.