We had this issue over the weekend on a SQL 2008 R2 instance. Does anyone know why this happens? Is there a patch for this?

After some more research it seems the suggested way is to manually detach the databases then reattach manually in a DR scenario.

Actually I think all I need to do is create two or more accounts and assign these to a profile...

I finally got this working by putting the -m switch at the END of the startup parameters. I then started the SQL Service (while having the SQL cluster off-line) then...

I run this but get the error:

The SQL Server (EARPSQLCL05) service is starting..

The SQL Server (EARPSQLCL05) service could not be started.

A service specific error occurred: 17058.

More help is available by...

Can you elaborate on this bit?

Then start SQL using -m and give it an application which you will connect with (Management studio or SQLCMD), as it is more than likely...

This is part of a cluster and cannot bring it back on-line now using -m? Any ideas?

Does anyone know why the transfer logins task in SSIS has done this?

Will this work even if there are no AD accounts on there? At least i can't see any??

Thanks Lyn.

I've managed to analyse some of the execution plans and changed the indexed columns. Having a covering on index(Date, Database)) is the best solution.

Thanks Gail. So from the first article if a WHERE clause has the two columns it seems that a single index containing Date and Database would be better?

However, if the...

This is what i was after!

http://sql-articles.com/reporting-services/how-to-rename-your-existing-report-server-database/

The issue has been that the user has their own AD login with db_owner but they are also a member of an AD group which has db_denydatawriter. So when...

Thanks.

Yes that makes sense.

So you can either have a default instance OR named instance for a SQL cluster, but not both. Also, you can't use the same cluster name...