There is nothing you can do to the log in simple recovery model.

A full backup will not truncate the log for you. Only log backups will manage the log

My...

George

snickers

Monastery

The OS is Server 2012 R2 Standard,

Total server memory is 64GB, but the OS is showing 61.9GB used,

It's a Hyper-V VM set with a static memory allowance of...

Using sys.dm_exec_cached_plans to see what's going on also outside of spotlight.

There are a few procs with recompile in the system as they have a wide range of parameters...

Sorry all, got this sorted, installed it to a subfolder rather than the root, strange how it was only this cluster that gave the error but all is now good.

Thanks

Ant

Double posted the above

I was letting the install create the role, all of the shared volumes for backups data logs etc where presented to be selected at the shared disk selection.

It defaulted to...

Traditional lettered drives I believe.

I didn't set the cluster up from a Windows perspective.

I tried making administrator be the owner of the file within SVI and that still didnt work...

Connections <> Users/Devices, the app may create 5 connections per user logged in or per device. So you don't want to be paying 5x's more the amount you need...

Logon triggers or setting up a firewall will be the only ways to do what you need to do.

If the table is dropped each load then a simple select into will do the job, as long as the table name remans the same on each load

How many users or how many computers do you have that can access the application on that server, is the application web based, is it accessible from the internet?

Sounds like you will need to force remove logshipping by using the stored procs in MSDB to remove all the primary and secondary plans

http://msdn.microsoft.com/en-gb/library/ms189071.aspx#TsqlProcedure

I would then reconfigure the logshipping plan...