We have a new client. Their primary computer was acting a the "master database". Their secondary server was hosting the replicated data base. The primary server went down. We needed to know how to turn off the replication process. We did discover the ALTER DATABASE SET PARTNER OFF command for the replicated data base but then they went into "Database (restoring...)" mode and in 12 hours have not come out of that mode. So we managed to get a copy of the original data base off of the primary server and copied that to a new server and now we are using the primary database in a different environment. Is there another command to tell the "master data base" that there is no longer a "PARTNER" also? The primary server is running fine until we turn on SQL and then it is a dog. We think this is a SQL issue and not hardware as we originally expected.