Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lepeniotis
Yak Posting Veteran
75 Posts |
 Posted - 2008-09-12 : 08:47:42
|
| Greeding to all.Any suggestion for handling the Operations Manager Database?My questions are the followings:1. Recovery model (simple or full) Cause it is on simple and I can't have log backup which will reduce the size on the logbackup.2. Restricted autogrowth? It was set up at 3000MB but it was about to full and I changed it.Any suggestions for the administration of this DB??Thanks in Regard |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-12 : 09:01:25
|
| What about Rebuilding highly fragmented indexes? |
 |
|
|
lepeniotis
Yak Posting Veteran
75 Posts |
Posted - 2008-09-12 : 09:06:02
|
| I did that but Operations manager its going to be a really huge DB and I can't understand why it was built only for 3000MB and resticted growth. The previous OpsManager was 45000MB and not unrestricted autogrowht.I aslo checked at that bloghttp://ops-mgr.spaces.live.com/blog/cns!3D3B8489FCAA9B51!171.entry but I don't have any reply.Thanks |
|
|
|
|
|
|
Operations Manager 2007 Database