Thanks for valuable advise guys.

Question. How do I estimate the size of Full backup file?

Is it going to be close to the size of data file?

I don't have enough space on local drive.

I don't think there is anything with cards or routers.

As I mentioned I did a test. I copied 1 GB file to this...

I know there can only be one default instance.

I'm just asking if we can have multiple "named instances" on our future cluster sql server.

Thanks anthony.green.

Does it have to be a Domain account?

Guys,

So how exactly ATTACH works?

It creates a new database from MDF,LDF files?

With stored porcedures, Users, Roles - everything?

I don't even know how that "Local System account" looks like.

I guess it's different on each machine.

I tried to work around and granted "Everyone" FULL CONTROL on that network folder...

Guys!

I am trying to come up with a good testing strategy to test Applications connected to a consolidated SQL Server.

Do we need to have a DEV Application server, install all...

SGquared,

I was able to install IGNITE.

Looks interesting.

I just requested Trial Key to be able to view reports

and drill down to a server.

Thanks a lot !!

Rob

Thanks for your message SGquared !

I tried Ignite software but it can not connect to my SQL Server 2012 Express instance.

Actually configuration instructions on their support website are not so...

A comment to SSCrazy reply.

Why it has to be acceptable for all applications to be down at the same time? What if we move databases slowly, one by one, to...

Thanks GSquared,

Very useful suggestions. Thanks a lot.

A question.

I have not created benchmarks.

How do I create them?