?
Solved

SQL Server tranlog - backend to MAXIMO

Posted on 2005-03-28
1
Medium Priority
?
2,382 Views
Last Modified: 2010-04-30
I have been given the assignment of administering SQL Server in my company (new job).  I have been a SQL Server DBA for many years, and I am familiar with the various flavors of backups and the various backup strategies.

We're using SS2000 as the backend to a MAXIMO 5.2 system.  One of the first things I noticed is how huge the tranlog on the MAXIMO database is.  The reason it's grown so much is that the former DBA wasn't doing tranlog backups, so the log wasn't getting truncated on checkpoints.

This is more of a MAXIMO question than it is a SQL Server question.  I know next to nothing about MAXIMO.  Is MAXIMO going to care if I institute a more conventional backup plan for SS, i.e. Full Backups, Differential Backups, and Tranlog Backups?  When the log gets truncated, is MAXIMO going to blow up?

MAXIMO documentation is surprisingly difficult to come by.  I hope there's someone out there who can help.

0
Comment
Question by:guillotj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
wwilliamx earned 2000 total points
ID: 13743226
>This is more of a MAXIMO question than it is a SQL Server question.  I know next to nothing about >MAXIMO.  Is MAXIMO going to care if I institute a more conventional backup plan for SS, i.e. Full >Backups, Differential Backups, and Tranlog Backups?  When the log gets truncated, is MAXIMO going >to blow up

No Maximo will not blow up. As you stated your previous DBA wasn't doing his job. So definately institute a backup stategy ASAP.

Wes
(Maximo user since 1992)
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Note: You must have administrative privileges in order to create/edit Roles. Salesforce.com (http://www.salesforce.com/) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales and marke…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month10 days, 18 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question