Thanks for the help. I granted SQLSERVERAGENT rights to the needed directories and it now runs.

Since we have some active / active clusters, I configure my max memory for each instance, so there will be enough reserved memory on a node to at least allow...

Our shop is has taken virtualization to almost an extreme. The VMWare team has modified configuration files so they can build a SQL Server from the ground up w/o...

Here's one that came up recently in my shop. The abuse of tempdb. Developers creating temp tables, then creating indexes on temp tables in a highly transactional environment....

Hello

Maybe this person should meet my wife, head of Cardiology at her hospital. She'll have some technical content to deliver!

Hello

Thanks for the reply.

I can realize a large cost savings if I can use SE. There are no features in EE right now that my company needs. We...

Hello

In reference to VAIYDEYANATHAN's post

I'll interpret your reply as True, only EE will take advantage of the memory exposed through PAE

Thanks

Hello

Is it also true that you must be running SQL Server 2005 EE in order to take advantage of the space available by using PAE? Standard Edition cannot use...

Hello

Reference Books Online:  DBCC SHRINKDATABASE.  You can schedule a SQL Server Agent job to execute this command on your databases.

Hello

Books Online:  "Estimating the size of a table" and "Estimating the size of a table with a Clustered Index"

I suppose if you have the name and path some files you can use the Restore Headeronly command to verify the files are what you want.  See BOL for more...

Hello

If you backed up your database to disk like :

backup database northwind to disk = 'nwbackup.bak'

Sql Server creates a folder:  Program Files\Microsoft SQL Server\MSSQL\Backup\

and places the files there.

Hello

My experience has been to

• Suspend Log Shipping
• Do full backup
• Do full restore on warm spare
• Resume log shipping

I would resume transaction log backups immediately after the full backup.  When the full restore...

There is also a good online article titled, "Why DBA'a Must be Jack-Of-All-Trades" by Craig Mullins, dated Sep 13, 2002.  You can find it on http://www.informit.com or do a...

This is taken from MSDN:

Multiple Instance Recommendations

Before installing multiple instances of Microsoft® SQL Server™ 2000 on the computer, you should be aware of the resources each instance will be...