This gets me my info:

restore filelistonly from disk='e:\mssql\backup\lyris\Lyris_db_200412150200.BAK'

Change names, and paths of course

At JD Edwards, our warehouse ran on SQL Server, 1 app server, 2 web servers, and we supported a 600+GB database very well. Ran much better than the 12 server...

That's good .

It does sound a little strange, doesn't it?

Does Veritas not have a solution? They should connect by instance name, where the ports are resolved by querying 1434 for the port of that instance.

Any reason you don't want...

If performance is an issue, re work the design or buy a bigger box.

I have seen this when a server was under high load. We talked with MS and they said to turn off parallelism. I thought there was a post SP3 fix...

How about this?

update p

set totalapps = b.apps

, totalgials = b.goals

from player p

inner join (

select a.playerid, sum( a.apps) 'apps', sum( a.goals) 'goals'

...

Update the statistics on the table. This can get out of synch. Also, you should have a clustered index on the table (indid =1), which ensures accuracy most of the...

Low end solution, Servers Alive (http://www.woodstone.nu/salive/). I used to use it and it worked great. Drop it on a workstation and set it to alert you.

sp_oamethod @objecthandle, 'Add'

Need a handle the the Jobs object before you can do this.

Is 445 UdP blocked sometimes? Are the servers setup on specific ports?

No, you'd have to set triggers on all tables. Or set a job to go through periodically and just set all data. Be cacreful of logging if you do the...

I've seen it before, but only for SA. We've used the IDS and firewall to block them and trace back, but it usually goes nowhere.

Are both machines in a domain? If not, I've typically just used SQL authentication to get around this.

Are you looking for one database or all? One is easy, all requires some more work to get this to work and return in one result set.