Post reply

Trying to Drop Database ! But Cant

  • July 31, 2006 at 9:31 am

    #169213

    Hi,

     

    I have a database, which the disk has gone dead, luckily for me, I had a backup, this database was also involved in replication, but now that I have restored the backup, to DBname_V2, I cannot drop the original database, it keeps saying its marked for replication.

    Having tried the sp that would remove it from replication, this doesnt seem to make any difference.

    Anyone know how I can forcefully drop this database ?

    Thanks in advance

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • August 1, 2006 at 12:10 am

    #652513

    Try taking the database offline, then dropping it.

    alter database DBName set offline

  • August 2, 2006 at 4:05 am

    #652761

    Hi

    Thanks for reply, tried doing that, still no joy.

    Thanks in advance

     

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • August 2, 2006 at 4:29 am

    #652765

    Try sp_removedbreplication [ @dbname = ] 'dbname'

     

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply