Thanks Paul and ALZDBA for clarifying that for me. I wasn't exacly quite sure how it would work, and I have not been able to find a lot of information...

Paul,

The article stated this about locked pages in memory and AWe:

AWE is something that is required on...

Since AWE is enabled through the OS, it is possible that you may be able to increase the size of the max memory value and see SQL increase the amount...

In my work place they are trying to get us to go to NetApp's SnapManager for SQL. I tested an older version, 2.1 and it had several setbacks. The biggest...

You could use transactional replication to get what you want. Alternatively, you may be able to get what you need from Log Shipping. The only thing is I do not...

That may not be a choice though. I know I still support many applications that my organization either does not have the will to upgrade to yet, or there is...

I think this is the wrong forum. If you are talking about replication between two SQL 2005 boxes, I think your question would go there. This is for 2000 replication.

What...

These technologies are for different platforms. DTS is a SQL 2000 technology standing for Data Transformation Services. It provides COM+-based tools to build packages to perform ETL operations on data.

SSIS...

If you know the usernames of the individuals you suspect, you could also setup a profile trace capturing UserName and NTUserName and add filter to those individuals so it only...

You haven't happend to notice the size of the tempdb files before and after the errors occur, do you? I am curious if file growth while heavy I/O is going...

Not a lot of information here. If you view the history of the maintenance plan it should give you the details of the step it failed on (as well as...

By the looks of the command it is backing up the log, but traditionally you would not end a transaction log backup with .bak. I think this is not so...

Another thing to note is that if you are in full recovery mode you will need to watch the transaction logs and make sure they are not growing out of...

Instead of going through the maintenance plan wizard, what happens if you create a new maintenance plan and just add jobs for the backups that you want done and try...

If the log fille is 99% full, I agree with the suggestion of doing a shrinkfile. That should reduce the use size of the log file, taking out the whitespace...