Amazing,

I spend a few days on this, searching and looking and trying just about every option.

As soon as I post for help, I stumble accross the answer.

So, in case anyone...

Thanks for the reply nix,

Correct you can have multiple MSDTC's installed and this is actually preferred and should be best practice. If your application requires the need for DTC and...

If this is Intranet facing then you will be able to use a CAL

If this is public Internet facing then web licence is required.

How ever many different users there are...

Hmm Not sure if anyone knows the answer or doesnt understand my question.

After furthur investigation it appears the best practice is to install seperate DTC resources with IP addresses and...

With no mirroring, clustering then I would suggest all you have here is a form of backup.

If one of your 3 servers did go down. And you bring this backup...

you will need to disable the instance in your cluster resource group.

Once disabled you can then stop the service without any failover (as the resource is disabled)

Hey thanks for that George,

I did forget about the extra license issues but making full use of both the servers will be worth it in the long run.

Does any one...

Default location is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA

Branch down System Databases, Right click tempdb > Properties

Select Files and confirm the default location there.

For I/O performance it is wise to place your...

Sorted,

Would help if the accounts was apart of SA

Additional information:

This is setup on 2 64bit 2003 Virtual machines

Using 64bit Standard edition.

No Witness

All instances are running under the same domain account

What was happening? Well everytime i tried to backup the log file manually, using t-sql or starting a agent job I would get this error message.

My good mate google...

Resolved:

I gave both log files more space and whala' all working

If only the error was more meaningfull

Again thanks for your advice.

I have suggestered a change to Nightly Full backups followed by logs every 30mins.

Thanks for your input,

Sorry, the differential backups are taken every hour during the day.

Which to me defeats the point of having a log backup once at 12:30pm

They expect to be...

Yes that is correct.

Target memory is amount of memory sql server can use while Total memory is amount

of memory sql server is using

How much memory do you have and...