Hi Markus

What executable (e.g., sqlservr.exe) does your script monitor for CPU usage?

thanks

Ian, you are the man!

I did some testing and determined that our backup system (we use Veritas NetBackup) was the cause. It consumes space temporarily as it backs up "open"...

Thanks for the help Jon. And everything here is NTFS, not FAT32.

Nothing out of the ordinary.

And it says the samething that the SQL Log tells me, "Operating system error 112(There is not enough space on the disk.)."

Hi Steve

Yes, I performed these tests, again, today.

1) I deleted ALL Backup Files and there was 21.1 GB of FREE SPACE on the BACKUP DRIVE. I then manually ran the...

Thanks Ian and Steve for your quick replies. 🙂

1) If I manually run the Backup Job it completes fine. If the SQL Job performs the Backup Job, it FAILS.

2)...

sorry, but could you please clarify this statement and the value/variable that it should be filled with?

INNER JOIN sys.filegroups f

Also, why are some of these NDF files so much larger than others? Is that due to the TABLES/INDEXES that are contained within them? Shouldn't they all be relatively the...

BTW: I'm new to SQL2K5 and don't know how to do...

Yes sir, once.

However, last night I did a database SHRINK (I know I'm not supposed to do this, but this system is still in development and I not given...

All MDF/NDF files were initially 500MB.

"dbcc showfilestats" info:

TotalExtentsUsedExtentsName O/S Current SIZE

80004083 ...

Thanks Pradeep.

But, 9GB of free space? That seems like a lot.

BTW: The database RECOVERY MODEL is set to SIMPLE. ALL database files are set to grow automatically by 10%....

We use VMware ESX 3.5 for Development, QA, Staging and Production.

Thanks Lowell. I shall try that!

Thanks for all the information.

Also, I want to shrink (or RECLAIM) the space that the REORG/REBUILD of an Index consumes. Disk space is always an issue.