Hmmm .. I did this very successfully about 6 years ago - the important point for any dba is always have a backup strategy, I deployed 2 pci-e flash cards...

Yes it's a valid / good idea BUT ... if anyone dev or other has written a select *  then adding the column will break the query.

I can't say this is anything I have ever noticed.

Hi Steve - thanks

just to clarify .. our current setup for all our applications which store state is to use a state database on the same cluster as the client...

You are making the same basic mistake everyone seems to with DR and HA .. yes multisite clustering is great .. but this has to mean you're using multiple storage...

I've a suggestion - set your checkpoint to a manual interval which isn't 4 mins - just to make absolutely sure.

No-one have their state database in the web tier or on a separate server then?

Am I unique in following this solution?

Log shipping is simple to maintain but does give you a read only database - this might not be what you intend.

Log shipping can deal with just about everything you...

If it works why make changes .. also nics belong to windows not sql .. I don't see why you would think network setup would change with a sql version....

sorry should have said only the dba team have sa rights and local admin to the dev sql boxes - the agent service runs as a domain service account which...

I have a whole multitude of automated jobs which do exactly as you state.

use MyDatabase;

--

CREATE USER [MySQLUser] WITH DEFAULT_SCHEMA = dbo;-- SQL User

CREATE USER [ThisDomain\Developers] FOR LOGIN [ThisDomian\Developers];-- AD...

I'm guessing that the start from date for your second job isn't 3 months to your required run date. Your schedule is set for every 3 months based upon...

I have to admit I have failover clusters and availability groups but not together.

I have heard that you can use a failover node as part of the availability group.

You would...

Much as I dislike generalised articles about setting up SQL Server, and I disagree with much of this article, it does provoke discussion and my fellow DBA and I had...

shows on my SSMS - sql 2008 running on w2012 cluster. I actually use SQL Diagnostic Manager for monitoring so this will alert me if the service is offline.