Re: Offline defrag

Having 10GB of whitespace in databases this big should is expected and should not be cause for offline defrag.
How many users you have and how long backup takes? Hopefully, you are not doing brick-level backup.


John Smith wrote:
Hi all,

I am new to exchange, we have recently migrated from lotus notes, where users had unquoted mail files. When we have moved to exchange 2003, we have decided to introduce quota with the mail system. so we've created couple mail stores - 8 in total - and moved users about.

since we've moved users about, out database grew from 370gig to 680gig. I have checked the event log and there is a lot 1221 event id, it seems that each mail store has approximately 10gig of free space.

the other thing, our backup has also taking hit, it is extremely slow, it takes forever to backup. the exchange through put for the backup has takes a huge performance hit. I think the backup time interferes with online defrag, I know the obvious thing to do is run the backup another time, but because of the size of the databases being backed it is continuously backing 24/7.

I have heard about eseutil, but alot of people are advising against it, I don't have a recent backup either, I want to fix all this issues before it becomes a nightmare.

please advice.



--

Text from most Windows dialogs can be copied to clipboard with Ctrl-INS.

Free productivity applications suit - www.openoffice.org
Free Internet calling - www.skype.com
Free SQL database Firebird - full support for transaction control, triggers, stored procedures, partial SQL-99 compliance
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1142758270:704186&page=what_is_interbase
.

Relevant Pages

  • Re: Database Maintenance Plan Problems
    ... the system databases such ... Deleted by Maintenance Plan ... >>A maintenance plan job to backup transaction logs ... >>Backup can not be performed on this database. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Maintenance Plan Problems
    ... >may want to create separate maintenance plans for the system databases such ... Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan ... >A maintenance plan job to backup transaction logs may fail. ...
    (microsoft.public.sqlserver.server)
  • Re: database log truncated, transaction log backup job failed
    ... I got it fixed by selecting the specific databases in the Maintenance plan. ... step that runs the transaction log dump". ... Unfortunately, I recall now, that maintenance plans do a good job of ... it seems like the only time you need to backup the transaction logs is ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup SBS 2003
    ... >> backup your system successfully. ... We shouldn't backup the Exchange log files since we are backing ... With the databases, you can decide to move the Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
Loading