Exchange 2010 Circular logging after some LOGS were deleted

New customer...   Under Exchange 2010  Database1   DOES not have circular logging enabled and local tech has been DELETING LOG files to keep server running and prevent hard drives from filling UP.

VSS backup fails because of missing logs....  DUH!!!!

Emails are working FINE...

How safely can i ENABLE circular logging  on Database1 ???  Even though they are missing GBs of LOGS ...... i'm not sure how the database will reload after the dismount......

First time this happened... so i'm afraid to enable it.....


Thx!
diascmAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will SzymkowskiSenior Solution ArchitectCommented:
The log files do not need to be present to backup the database. The log files are only ever needed in the event of database corruption and you need to restore from backup. At that point you would restore your most recent backup and then reply the log files that were not committed to the database before it failed. If you enable circular logging it will be completely fine.

However, you need to be sure that you know the consequences if you enable circular logging. Basically you will not be able to recover any email after your Full Backup as the logs will continually get overwritten.

Will.
0
diascmAuthor Commented:
Normally I do a FULL VSS backup to grab the DB and Clear the LOG files.... in this case the FULL BACKUP fails because of the missing log files....

What do you suggest to backup before i enable the circular logging (customer request).

Thx!
0
Will SzymkowskiSenior Solution ArchitectCommented:
When you enable Circular Logging take a full backup of it after it has been enabled. If you want to be cautious you can always move the logs into another directory before enabling circular logging.

Will.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

diascmAuthor Commented:
i was trying to figure a way to BACKUP the DB before i enable the circular logging.....   (was affraid of it reaction for the dismount/mount required to enable circular logging)

So basically  i can just enable circular logging and even if there are missing log files the database should dismount and Mount without any issues and will delete the orphan log files that are still in there??

thx!
0
Will SzymkowskiSenior Solution ArchitectCommented:
The log files are only for recovery thats it. They do not have any other purpose other than that. When information is changed in a database (deleted items, move mailboxes received mail, sent mail etc) these are written to LOGS which are then committed to the database.

When you run a full backup of the database it backs up the database and purges the log files because those log files are in the full backup of the database itself so they are no longer needed.

So i am not sure why your backup is failing due to log files? However when you enable circular logging all of the logs get over written, so at best if you were to restore your database you could only recover mail from the last Full Backup becasue the logs after the Full backup have been overwritten from Circular Logging.

Does this make sense?

Will.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
diascmAuthor Commented:
Yes.... will give this a try tomrrow night... managed to do a backup today!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.