Thanks for the advice.

I did look into CAL's, but since one of the main applications will be an intranet based tool, and we have over 100 employees (although initially only...

Thanks for the advice, I will certainly make backups prior and post, probably image the entire system (not too big, just 250g or so).

I just took the smallest DB I...

We don't have spare hardware available 🙁

IT runs on a shoestring...

I don't have full control of the clients unfortunately, as there is some old software distributed throughout the company...

I guess I will need to have the 2012 instance named something...

The remote tns_admin works fine for tnsping, but fails in sql server linked servers, I will try reconfiguring for local tomorow, like my other server that works and hopefully that...

I see, I took you statement about the native client to mean "SQL Server Native Client 10.0"

The other drives are installed, however I have been unable to get them working.

On...

I thought this was only for connections to other SQL Servers?

I tried it and it doest work anyway.

Marts

I'm sorry, I meant the .ldf file associtaed with the distribution database that is on the same server.

I am struggling to move it, from what I have read, you should...

I had a feeling that may have been the case with log files :hehe:

So another question we have replicataion going on here too, should it's log files (if any) also...

Not just you 😉 I keep looking at those orphaned files and want to move them.

When I created the new expandable log files, I created two per database that was...

Anecdotally (ie not looking too hard yet) I am seeing some positive effects of moving the log files into their own disk array, cpu is lower, several queries that get...

I can check with my IT guy to see if something can be arranged. Does the tempdb storage need to be quick, or just seperated from other stuff?

Hmm chkdsk /F...

I appriceate the feedback, quick comment here, the server has 8 physical disks and a hardware based raid controller with 2 channels.

Currently I have one system mirror (degraded and trying...

Well, I found something very wrong that I think I can fix realitively easily... I have no idea how the IT guy missed this, but I went into the dell...

Yeah pagefile was just some sillyness, a random thought.

On our current setup without any modifications, I could move the logs and/or the tempdb to the system drive (raid 1), away...