asked on

SCSM 2012 DB re-location

We have SCSM2012 installed and configured to run with SQL2008R2.

I have 2 issues: The DB log files are huge (even though we are not running the SCSM yet - only trialling it) and cannot seem to find where I can re-point the SCSM DB to another SQL server, as I'm trying to see whether I can replicate the extreme growth of the SCSM DB logs.

didnthaveaname

Is the database for SCSM in full recovery model? If yes, you have a questions to answer: Do you need point in time recovery capabilities or are you OK with losing however much data between your full/differential backups? If you don't need point in time, change the recovery model to simple and that will limit the size of your transaction logs. If you need point in time recovery, then you're going to need to setup a backup plan that involves full/diff backups with transaction log backups, or else the transaction logs will just continue to grow until they consume all space on whatever drive they are located on.

A good introduction to maintenance plans for backups: http://technet.microsoft.com/en-us/sqlserver/dd430301.aspx

Biertan

ASKER

I do not have any issues with losing the current data in the DB, however the size of the logs are concerning me: they seem to grow extremely fast although the SCSM is not utilized - I'm trying to find out how to restrict the size of the logs for the SCSM DBs and how to potentially move to another test SQL server, however I can't see where in SCSM 2012 I can point to another SQL server.

ASKER CERTIFIED SOLUTION

didnthaveaname

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Biertan

ASKER

Thank you very much