I figured it out

1)Set up AG

2)On day of migration remove databases from AG

3)Do full back up of db on current prod server.

4)Do tran log back up of db on current...

Personally I am not a fan of using multiple instances on production machines. I find management and troubleshooting machines with multiple instances a lot more work than single instance...

So are you talking about having 150 instances of SQL Server? How many servers do you have available to host all those instances?

Are there are requirements that a tenant's...

I think we ended up causing our own problem. We were attempting to restore to a new database that we had set up off a restore of the primary...

After the restore of the read write filegroups the read only file groups have a state of RECOVERY_PENDING. If I run

RESTORE DATABASE X FILEGROUP='FG_readonly'

WITH RECOVERY;

The read only files have...

It was the distribution clean up job blocking the log reader. I fixed the slowness using the steps from this article.

http://www.replicationanswers.com/TransactionalOptimisation.asp

I don't know how many sprocs you are running during your test but the first thing I would do is look at the execution plans of the sprocs. The...

Are they all in the same publication?

Lowell (5/5/2011)

---

John I'm not saying this is the right way to do it, this just happens to be how I thought it might work;

how about creating a table CustomerAlias, and...

I disagree somewhat with the other posts. In my experience Sql Server 2008 backup compression is on par or better than sql litepeed (when sql litespeed is used with...

questioned answered here

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/

Are you on a 64 bit or 32 bit OS? 64 or 32 bit sql server?

We use transactional replication on a 2008 publisher with push subscribers who are sql 2005, sql 2000, and sql 2008. No problems so far.

Makes sense. Thanks for the reply. I thought we had the same issue when it was set to asynchronous mirroring but I will check it out again.

Thanks again.

Yep that did it. Thanks very much for your assistance.