To answer the original question, build a new VM Machine and spec it accordingly. Setup Log shipping, Mirroring or AlwaysOn. Fail it over and monitor performance. If not happy with...

When you do a log restore manually you should get something like this.

Processed 2 pages for database 'Testoct2', file 'test_Log' on file 1.

RESTORE LOG successfully processed 2 pages in 0.074...

You'll need this sp too.

USE [ABCDBA]

GO

/****** Object: StoredProcedure [dbo].[ABC_BuildRestoreScript] Script Date: 06/03/2010 22:06:42 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[ABC_BuildRestoreScript]

@dbname sysname = '' ...

This solution may have the SSIS package you are looking for.

http://sqlcat.codeplex.com/wikipage?title=sqlauditcentral&referringTitle=Home

Presumably you are using firewalls between your web servers and your db servers?

Can you NAT the ip address from the primary db server to the secondary db server using the...

I think you need to find out why the restore of the log file is taking so long.

Do a manual transaction log restore (i.e. restore log abc from disk =...

I haven't tried this, but you could try

1/ Suspend mirroring and Transaction log backups

2/ Take snapshot on Target 1

3/ Backup snapshot on Target 1

4/ Restore snapshot on Target...

Hi Moss

Try these three sp's

ABC_Mirror_Create

ABC_Mirror_Sync

ABC_Apply_TransactionLogs

They will allow you to backup and restore databases from one server to another and then start the mirroring.

We use these to Synchronize whole servers (up...

You only need to license the primary site, as long as you have the same number of processors in the two servers and you don't intend on running for more...

What method are you using to connect to your SAN.

Fibre channel or iSCSI?

We had a situation where the iSCSI service wouldn't start before SQL Server, rendering the databases suspect.

We got...