[sims] Can you safely shrink SIMS DB in SQL Manager

[robjduk]

Hi,

As the title says, is it safe to go into the SQL management and shrink the SIMS database? I was given some patches however they don't work and was eager to sort this out over the weekend where possible. Not sure I see a downside but best to check.

 

Thanks

[PlantHead]

Generally it is a bad idea to shrink SQL databases. If you use DBCC to shrink the DB you will end up with heavily fragmented tables which will effect performance.

Why do you need to shrink the DB? Space on the server?

[vikpaw]

Yeah, just take a backup first.

Were the patches to shrink the dB or for something else. If they were supposed to shrink it and it’s not worked there could be an issue and doing it manually won’t work either.

 

IIRC the shrink dB patch basically put the system in simple mode and flushed the log files.

 

If you have issues with the DB size it’s worth also looking at the auto grow settings.

[robjduk]

Thanks for the replies. Our DB has hit over 20gb and after looking on these forums it looks like it may be an InTouch problem.

[matt40k]

I know sometimes you have to set to FULL, then shrink the log file (important FILE not Database), then switch back to SIMPLE. Still you're SIMS Support team should be able to do this for you - 5 min job.

 

Be worth checking the backups also!

[ass17]

Re-indexing also can give better performance and is suggested to do twice a year. Speak to sims about this.