Another thing about your schema is that you are defeating the purpose of the transaction log backups.  As soon as you issue the BACKUP LOG WITH TRUNCATE_ONLY, you have broken...

I don't think it applies to 7.0 .  The one server I had that actually processed twice was a 7.0 server.

Steve

I do have the newsletter, but haven't looked at it. ...

Adam,

I will admit that BOL does not specify that the EMPTYFILE option restricts log files as well as data files.  However, it also does not recommend using it for...

I'm not sure your error has to do with autogrow.

Please see:

http://support.microsoft.com/?kbid=816840

and

http://support.microsoft.com/?kbid=867878

As far as shrinking/expanding/adding database files, it would be helpful to have more information about the current condition...

Frank,

I always thought that shark was just an avatar.  Now I realize its really you!!!

Stu,

It IS two different things, but unfortunately related, as TRUNCATEONLY...

Edited post...

With a query the size of the one you are working with, this will get really ugly, but, you can do this with dynamic SQL (which is generally frowned...

Don't update the system databases directly!  In your fat database, fillfactor is set to 25, which means each page is only 25% full, leaving 75% open space.  In your other...

Terry, I won't tell you that my way is better than anyone else's, but if you decide to go that route, when you script the database, you have an opportunity...

Sean,

I think your suspicions are correct.  The space is taken up by fill factor in the indexes.  I would try again to reduce the fill factor.  You can use DBCC...

Adam,

from BOL (look up DBCC SHRINKFILE):

EMPTYFILE

Migrates all data from the specified file to other files in the same filegroup. Microsoft® SQL Server™ no longer allows data to be placed on...

In Enterprise Manager, right click on the database, select "All Tasks", then "Generate SQL Scripts".  In the dialog box that comes up, click on the "Show All" button, then select...

If you use the EMPTYFILE option on the SHRINKFILE, you will render the file unuseable.  EMPTYFILE is only used if your goal is to completely delete the file.  It prevents...

Thats your BrightStor (BEB) database file (used to be ArcServe).  You'll need to check with your network admin that takes care of the network backups to ensure that he is...

For the record, sp_update_job is in the MSDB database, and the rule about stored procedures beginning with 'sp_' doesn't apply.  My daylight saving time adjustment job was pointed at the...

John,

Thank you for your response.  I think you are probably right.  One caveat... The editor that I used was........drum roll.....Microsoft SQL Server 2000 Query Analyzer!

Steve