Hello,

thank to reply,

It was asked for me to create a database following some "best practice",

one of these was to set the number of files to match the number of CPUs...

Hello,

thank for the link above, but I have already read it and it is very useful.

But I need more help on how to manage filegroup that should be stored (backup),...

Thank for you contribution,

any help further help or suggestion will be very useful

Thank

Any help will be very appreciated.

Thank

Hello,

I do not if it may be useful, but "SQL Server Browser" is enabled?

Hello,

I would like to post it, but data are too sensitive to be shown.

In any case I would like to try it again and see what happen.

Thank

Hello,

late or not, each contribution is welcome, also for other people needs for info.

Thank

Hello,

I understand the problem but what I miss is:

why I cannot access the entire SQL server? After the script ran, I cannot access neither SQL Server instance nor any databases....

Yes, I used also Windows authentication (it is written in the first post).

Anyone can explain what happend, otherwise may be a big problem in the future running script

When I run the script on the first server, also the login were scripted.

But I do not understand why after I run the script on the second server I was...

hello,

I connected remotely and locally.

The error is the typical error code when login/pw are wrong (at the moment the SQL server is already installed), but please, do tell me If...

Hello,

thank to everybody for your useful contribution that may help to plan and organise my new adventure.

Some of your suggestions were already used, other will be analized in depth and...

Hello,

thank for your contribution,

I have alraedy taken into consideration to spread files into different logical disks on small-medium db and thus in VLDB.

I will check any suggestions around interest.

Any other...

hello,

the problem is that DBs are different from several client so it is very hard to follow each change.

thank

Hello,

I have to copy the database structure, but the problem is that the dataabse structure change everytime, so I need something dinamically that create all objects present in the database...