Hi,

What is your setup of the replication

How many publisher

How many subscriber do you use

Did you use a distributor-server, or is the distributor on one of the publishers?

Do you use...

The problem is solved.

The Subscriber had massive problems with the hard disk.

Hi,

here is a link how to create alerts.

http://technet.microsoft.com/en-us/library/ms366332.aspx

If you had created them, you can script them yourself. It is very easy

Andreas

Hi,

you can use sql scripts from dbWarden. Here you got an email if there is an autogrowth on your database.

Or you can configure alerts in the SSMS.

Hello,

have you looked this page from Ola Hallengren:

http://ola.hallengren.com/

There a ready jobs for backups, full, diff and log. You only had to schedule the jobs.

could this script fix this problem?

use master

alter database [dbname] Set Partner Failover

i am not sure if it works for a mirror failover

the problem is solved

i removed the witness from the mirror, and after a few seconds i add the new witness with the correct FQDN to the mirror.

i don't know if...

Hi,

on the witness-server are no entries in the errorlog. on the principal of the database are these entries:

2013-10-29 12:09:24.54 spid161 Error: 1456, Severity: 16, State: 3.

2013-10-29...

Hi,

here are the results:

1. Make sure the witness is listening on the assigned port. Remember that if you telnet into the port, that only shows that something is listening on...

Hi,

i am using the same login for all 3 databases. I am able to login from server db_01 to the witnes-server via ssms. I used the same port for the...

I read, it is possible to use the Express or Webedition, but it musst be the same version of sql, we use 2008 R2 on the servers, and it works...

hi,

i have got 3 databases, wich are mirrored:

Database | Prinzipal | Mirror | Witness

db_01 | sql_01 | sql_02 | wit_01

db_02 ...

Hi,

i think, you can't use you mirroring, because the mirrored database is read only, depends on the version of SQL.

it is possible, you have to change two values.

please be so kind and watch this thread:

http://www.sqlservercentral.com/Forums/Topic1482214-391-1.aspx

at the end, there is an interesting link.

with this, you are also able to add...

dbwarden

http://www.sqlservercentral.com/articles/Monitoring/98106/

http://sourceforge.net/projects/dbwarden/?source=navbar