I've seen SQL Server restart on a tempdb error due to a full tempdb but I dont' think I've seen the server reboot on its own. Can you provide more...

it has to be, as long as the thread has a physical connection sql server will keep it open forever, you may even get warnings about threads that have been...

We always try to preallocate to cut down on unchecked filegrowth. We have some databases with double the amount of currently used data allcoated so we don't grow the datafiles...

sp_addserver 'newservername', 'local'

Look it up in BOL

Wes

We use log explorer here in our shop. The only complaint I have is it isn't cluster aware so if you fail the node over it can't find the dlls...

I moved all our backups to use GMT time the backup and restore script compensate for DST that way I never have to worry about an overwritten file or that...

I would hard set the port of the named instance if it is comming throught the firewall. The listener will pick a random port if 1433 is already taken by...

when we moved re rebuilt the server and then ether restored the databases or copied them over. We scripted out all users,permissions, and user objects stored in system databases. I...

Are you tring to get a list of users from AD and store that?

Wes

SQL Server 2000 Performance Tuning from Microsoft Press covers hardware setups in detail.

Wes

backup files are just files. I'm not sure exactly what you are asking for.

Wes

Rebuild of of master or a reinstall is the only things I can think of.

If you are talking about stopping replication then clustering the server and trying to start replication back up again. I doubt it will just start back up. I would think...

Extremely high loads for long periods may cause the hartbeat to fail for long periods and may cause a failover. I haven't seen it happen often but it can. Anything...

dbcc checkdb checks every aspect of the database in a quick manor, this includes the log

Wes