No there won't be a performance improvement in simple mode as the log file is still is use but will get marked for re-use. How many rows are you deleting...

There is no way to run a delete statement without it being logged. What is your recovery model? How many rows are you deleting? How much space you have on...

It's not possible and why would you want to? Are you trying to prevent your log file from growing?

Thanks

You can always use Task Manager to have a look at what is running besides SQL Server and go from there. It possible you might need to either add more...

Can you find out?

Thanks

Is it purely a database server or is anything else running on there?

Thanks

SQL Server will always use all the memory allocated to it. How much memory do you have on your server and what have set as your max server memory for...

Have you run the Validate a Configuration wizard and what was the result?

Thanks

Are you running it as an administrator?

Thanks

Are these the only 2 errors you can see? Have you been able to successfully failover in the past? It might be something like your dependencies aren't set correctly but...

Is there any additional information after the error message? It might be bacause your database currently in use. If so you will need to close all existing connections to the...

Did you receive any error message? You say that two resources were moved so some failover successfully and some don't?

Thanks

We use Spotlight and I'm very happy with but it is quite expensive. It all depends on the level of detail you need and of course your budget. As has...

Just to be clear you can perform hourly transaction log backups AND daily full backup backups.

Thanks

Also just to add it may be worthwhile looking to upgrade the version of SQL Server you are using to take advantage of some HA features that have been added...