I would suggest mirroring as an addition, not replacement, to log shipping.  The two technologies are best suited for different purposes.

Mirroring gives you very fast failover, automatic if you want...

If you haven't done this already, turn on the ability for SQLExpress to receive remote connections.

All Programs > Microsoft SLQ Server 2005 > Configuration Tools >

SQL Server Surface Area...

I don't believe you can create database objects using a remote connection to SQLExpress.  You might need a higher level edition of SQL Server.

Bill McEvoy recently published an article in SQL Server Magazine where he provided a stored procedure called something like "sp_FindReferences".  The procedure accepts the name of a database object (e.g....

Have you tried examining the backup file with these commands?

restore filelistonly from disk='C:\MyFolder\Myfile.bkp'

and

restore headeronly from disk='C:\MyFolder\MyFile.bkp'

The contents of that backup file my give you some clues as to how the...

Stewart,

Books On Line has the T-SQL code to GRANT CONNECTION permission on the endpoint.  Perhaps if you ran that manually on the Witness, it would eliminate that specific failure you...

Stewart,

I am having the same experiece, except that the principal and mirror servers are running Enterprise Ed. and the SQLExpress is installed on a third server.

Setting up a two-way mirroring...

Noel,

Actually, in my brief testing, I was able to add the "identity" property to a column in one move in EM (If I remember correctly).

But that wasn't the goal.  This...

WORK!!? 

OK, I'll abandon this approach!

Thanks

Bill,

I have used the following, and it does not require the "over-rides" mentioned above.

USE MASTER

GO

ALTER...

Yelena, thanks.  I'll try that approach next week after I retrieve the backup tapes.  I'll post the results.

Elliott

Hi Deena,

If you are talking about a backup scheduled using a Maintenance Plan, it is very easy.  Find the Maintenace Plan by opening the Management folder in Enterprise Manager.  Right...

Got it. thanks.

I'll probably try changing the sort to descending, since the values are almost always going to be at that end of the range.

Elliott

Noel, thanks.

We have the correct ordering of the columns, I was just wondering if changing the sort order to Desc would speed up the insertion process because the current transactions...

Mathew,

This should be pretty easy.  After creating your Trace table (sometimes called an Audit table?), create a trigger for your subject table:

Create trigger MyAuditTrigger

FOR insert

AS

INSERT into TraceTable (Col(1), Col(2), Col(3), Col(n)ActionDate) values

Select...