Each db will range from 200GB to 800GB. Right now biggest is 800GB. But as days pass it grows more.

we are doing this from several years and we feel that we have to improve performance and users should not feel that downtime even for a minute. I am thinking...

KERBEROS authentication and also delegation were take care. I am sure they are working.

Is there any thing else i can try to setup my link server.

thanks

yes, both are configured for KERBEROS

Now I get this message

Msg 18456, Level 14, State 1, Line 1

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

OLE DB provider "SQLNCLI" for linked server "LinkServerRev" returned message "Invalid connection string...

yes i see that message.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 172.16.20.34]

I thinkg to update when run the 1st query on master db's it is listing all the db's...

Be made using current security context.

I did check, it has permissions over that database and the tables.

Yes I do setup my link server to use current users security context but still the same error.

I was just wondering why only my login shows KERBEROS why not service...

everything related to network is fine, itried pinging it was good.

to resolve this issue i just rebooted the server where I was trying to connect and everything is working good...

Are there any scripts out with automated backups for VLDB which has partitions based on each year.

WE have Db's with partioned file groups for each year and I dont want...

Ok I think SP3 was sucess fully installed. when i check

select serverproperty ('productlevel') it gives me SP3.

Now I would to test this server after SP3 and then want to...

when i checked on the server property at Version i see this

9.00.3042.00

Do you mean to say that I have to apply cumulative updates to the point before SP3?

Even before i applied SP3 it was showing this

Microsoft SQL Server 2005 - 9.00.4028.00...

Paresh

What if some of the backups fail and how wud i re run job from that point of failure so that i dont need to run whole job from begining.