renasoursou, try this;

create an alias for RLDB2,4949\RLDB2_05 and call it something like "monitor"

then change Data Source=RLDB2,4949\RLDB2_05 to Data Source=monitor

peleg (11/8/2010)

---

the only thing that i whould change, is running the vbs from windows schedule task and not from the sql server, i think it's more correct way.

This will give...

renasoursou (11/8/2010)

---

Hello,

your Article is really great. I tried to Run the Script on our Server (Windows Server 2003 R2 SERVICE PACK 1) but I get an error (see attached file)....

K. Brian Kelley (11/4/2010)

---

Geoff A (10/28/2010)

---

this is actually a "domain" policy. the users that have SSMS installed on their local PC's should be "not allowed" to control system services.

I am...

no.

but you might be able to do something like;

instance pair 1 mirroring on port 5023

instance pair 2 mirroring on port 5024

instance pair 3 mirroring on port 5025

the witness instance has...

i am running SQL 2008 developers edition on my MacBook Pro via a Parallels desktop running Windows Xp Pro SP3. it works fine for me.

we have 1 witness 'server', but each pair it monitors is a seperate instance.

so we have 6 database servers that are mirrored. (12 seperate servers)

we have 1 witness server with...

Steve Jones - SSC Editor (11/3/2010)

---

I would create new roles, and double check what rights are granted them. Using db_reader/writer is a way to unintentionally allow access to tables.

Make sure...

as the DBA supporting these databases, here is what I would do...

I would tell management that what they are doing is a HUGE mistake and introduce them to a VPN.

i cannot imagine any situation where you have to have an externally facing DB.

what is the reason why your company is doing this?

some of it has to do with the sysadmin role...

you cannot deny connect to a sysadmin, BUT you can disable a sysadmin login....

did you check your startup parameters? is there a -g in there?

Michael Valentine Jones (11/2/2010)

---

That link is about locating database files, not backups, on a share or...

they do not say NOT to do it, but rather say use caution;

http://support.microsoft.com/kb/304261

database mirroring in High Safety mode is the only thing that comes close. clustering is a waste because there is still a single point of failure... (the SAN)

I have been...