Thank to everybody,

I thought about replication, but I asked about LogShipping because I am not very experienced it.

So I will analyse the job to do in depth to choose the...

thank for everything,

turning on simple recovery, shrink and then to turn back, log file was reduced to small size.

Now,

I will try the code posted above ....

First of all: thank to everybody for your useful suggestions.

A question,

this problem is from a DB that I do not manage, I was only asked some help.

I have found out...

Thank very much

for everybody:

select name from syscolumns

   where id = object_id('nometabella')

   and iscomputed=1

thank for your useful suggestions

I add:

configuring DNS to solve server name

Very good!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

It looks working!!!!!!!!!

thank

After lots of tests and drilling down the problem, It looks like that authentication fails on clients when they access with ip addresses that are not in the first IP...

Anyone knows some good networking Windows server 2003 forum site.

Thank

Routing looks OK, I can access clients without problem.

The problem is SQL server, it looks reading only an IP address for NIC instead of all list.

thank

You have understood very well

Thank

Thank a lot

Ok, if there is somethying left out that do not necessarily hurt anything I agree with you, but I would like to avoid to leave "died" objects; anyone access the...

I mean that:

I installed SQL Server 2005 with 3 instances for example:

SQLtest1, SQLtest2, SQLtest3, then I Uninstalled SQL2K5 with add remove programs (removing each instace).

Then Reinstalled 2K5 creating an instance...