I do not have log shipping running anywhere to test this, but i will give you something to start with maybe...

select [name] from sys.databases where [name] not in (select primary_database...

firewall?

is it high safety mode or high performance mode? or in other words, do you have a witness?

Since you are calling a SP inside the trigger all errors needs to be rolled back before you perform any writes.

try adding IF XACT_STATE() = -1 ROLLBACK to...

use xp_getfiledetails.

if your SQL version does not have the spoc, create it like this;

http://forums.databasejournal.com/showthread.php?t=44193

OPENROWSET('SQLOLEDB','uid=sa;pwd=password;Network=WORKGROUP;Address=192.168.1.1,1434;timeout=5', 'SELECT * FROM MyTable')

is one way to pass a different port number.... see the comma.

The prefered way though would be to create a linked server entry and define your...

shaun.stuart (10/1/2010)

---

Good point - yes that would increase the time required before a real failover occurred.

Interesting that you assumed he was reindexing the mirrored database. I assumed the opposite -...

shaun.stuart (10/1/2010)

---

If it is due to the index rebuilds, you can change the length of time mirroring waits for before failing over. The default is 10 seconds. See here for...

winash (10/1/2010)

---

Replication will support schema changes if you set the replicate_ddl flag when setting up the publication - no need to stop and start replication to replicate schema changes from...

SQL* (9/23/2010)

---

which option will affect data and schema changes to the subscriber?

is mirroring support : schema changes to mirror server

is log shipping support : Schema changes to secondary server

is replication...

he has too. the failover could not have occured with out it.

database mirroring is done at the database level.

that said, i have seen many cases where a single instance that has many databases all mirrored start splitting up the way you...

it was more of a comment to the person that said they did not like the fixed roles SQL offered.

If you want more fine tuned control of roles to msdb,...

you could try 2 things;

1. under reporting Services Configuration manager, choose Database Setup and under the Server name, type in the port number is the standard SQL way, (local)\instance,5555

2. via...

if you do not like the bult in Roles, create your own with the proper GRANTS;

USE [msdb]

GO

CREATE ROLE [TestRole1] AUTHORIZATION [dbo]

Go

--- Step 2 -------- Assign Permissions to role ------------

USE...