Hi thanks for the reply.

Slight tangent but why wouldn't you use Win7 on a VM?

The SQL Instance is for a Monitoring DB (Ie for Red Gates SQL Monitor...

Sorry yes.. I did it that way! getting late in day mind is go a stray. No joy

thanks

Stephen

ive tried ip address and ip:1433 (its a default instance, no other instances installed on that machine)

and no joy on either..

C.K

you got me excited there! Ive managed to put them in the wrong way before and thought that be it! sadly they are in correct 🙁

Still not solved....

hi guys thanks for the replies.

so i thought of a few more things that it might be and have still had no joy connecting to it.

1: The new...

Sorry for the delay in replying

Thanks for the info!

I know the front end is a webpage. But i believe all the queries go though another server before hitting the...

Hi Grant,

Does it matter about the original size of the database? Do you still get a bonus even if the database is already small? (All our mdfs are 1-40gb)...

Hi thanks for the reply.

From what i had read. Therre was a slight CPU overhead for the use of compression but if you had spare CPU compacity (Our servers...

zach_john:

What SAN are you using?

LSI (Model im unsure off im afriad)

What are the size / speed of the drives you are using?

SAS 15k 150gb (Space will never be...

Update

So i can a connection via a ALIAS if i:

Create the ALIAS on my local machine not the machine that i want to connect to. And for a named instance...

Hi Cath Trimble,

Great ideas thank you!

Hi Guys,

Ive basically been told i have no time to do any tests on SAN when it gets here. so much as i would love to, its not an...

Hi,

Thats perfect! thanks...

S

Are you talking about Data Collector?

If so that only collects data from SQL 2008 boxs.

http://www.sqlservercentral.com/articles/Product+Reviews/66278

I think you would need to use something like sp_spacedused as i belive...

well good news!

they have connected via sqlcmd -S ip,port !

joy...

I can work my way though the process of getting them back to clustername\instance. I will also play...