You could also create a dedicated linked server SQL login on both servers with specific read/write permissions in a specified database if you did not want to grant sysadmin rights...

Assuming you are using a backup software such as Symantec Backup Exec you should be able to catalog the tape. It may take a while depending on type and...

It is a matter of preference. You can also detach from the 2000 instance and then attach to the 2005 instance. It typically takes a couple of minutes...

On the response tab of a new alert being created you could also have it execute a job such as a predefined backup job or shrinkfile etc...  There are many...

You may want to consider creating custom alerts under SQL Server agent.  You can create custom alerts to monitor any of the SQL Server perfmon counters such as datafile size...

I agree with most of what has been said here.  I would like to reiterate what Adam has said.  Check indexes, index fragmentation, updating statistics etc...  It could possibly be...

Because of the 64bit archictecture you no longer need to use the PAE switch in the boot.ini file.  You do not need the AWE or the /3GB any longer to fool...

If you are looking for a good DBA admin type book that covers SQL Server 2000 from start to finish I would check out Professional SQL Server 2000 Programming by...

I went through something similar to this with SQLServer 2000 Ent. 64bit.  It seemed that anything I tried the default action for SQL Agent is to use the NT authentication...

I am not one to advertise or sell third party products but about 2 years ago I began using RedGate SQL Backup for SQLServer needs.  I evaluated it against 3...

I cannot speak on the custom VB or C+ apps as we are not running any although I would assume they would just run as 32bit apps.  They only run...

We are running 64bit OS Server 2003 & 64bit SQLServer 2000.  If you have any 32bit apps they will have to run in compatibility mode which will slow it down. ...

There are definite benefits to going SAN.  It looks like you have a couple of disk arrays and appear to be configured pretty well.  I would say you could roughly...

We went through the same problem.  We had consultants in and everybody that used sql server knew the 'sa' password.  Its not as difficult as you might think on sql...

Has there been any type of database maintenance plan invoked recently?  I have seen where after running an INDEXDEFRAG or an DBREINDEX on all tables in the database that the...