Skip to main content
D
DamianCastillo1-Visitor
1-Visitor
March 21, 2013
Question

SQL Server backup logs

  • March 21, 2013
  • 5 replies
  • 1448 views

We are currently testing and configuring Windchill for our environment and we have ran into issues with the SQL Database logs. Our IT Consultant tells me that the logs get large and Windchill start having issues with them.


What general good practices have others implemented with SQL Server backup logs?


I have no idea about the database side of things and I am new to Windchill as well.


"Too many people walk around like Clark Kent, because they don't realize they can Fly like Superman"

5 replies

B
BenLoosli23-Emerald III
23-Emerald III
March 21, 2013
Restart the system daily with new log files. Move the old files to a directory.
For my Oracle files, I rename them and delete the dump file every couple of days. Only the latest is actually of any value.
For Windchill logs I rename them every night when I do a restart on the processes after hours.
File vaults which are on the Windchill server, I depend on IT to back up the server every night, after the Oracle dump is done.

Thank you,

Ben H. Loosli
USEC, INC.
D
DamianCastillo1-VisitorAuthor
1-Visitor
March 21, 2013

Holy Smokes. Sounds like I have a lot of learning to do. I apprecaite the response, but you just told me to do things I never knew about. Is this documented in the Windchill Guides or Training materials at all?


"Too many people walk around like Clark Kent, because they don't realize they can Fly like Superman"

B
BineshKumar11-Visitor
1-Visitor
March 21, 2013
Damian,

If you are talking about SQL Server Transaction logs, you can refer to

> they can Fly like Superman"
>
P
ptc-3038811-Visitor
1-Visitor
March 22, 2013
Hi,

If you have a disaster recovery plan that takes care of restoring database
backup and adding transactions logs and handling vaults then you should
use transaction logs on SQL server. If you dont have a plan you should
turn off transaction logs to gain SQL performance.

Best regards,
Magnus Persson



B
BenLoosli23-Emerald III
23-Emerald III
March 22, 2013
Here is a more detailed description of Windchill log files and backups.

I am not an expert in this, but this should give an overview to help some of you getting started.


Thank you,

Ben H. Loosli
USEC, INC.
Terms & ConditionsAccessibility statement