I am facing a problem frequently in CSA MC when I Shrink the database in the Database maintanence .I am getting error
Error: Shrink operation failed for database csamc52. See csamclog.txt for details .When I look in to CSAMC LOG The error is
SQL: shrinking db
[2008-10-08 02:26:11.643] [PID=4712] [Csamcmanager52]: DoFlushIfNeeded: Failed to sync events to database: 0x80004005
[2008-10-08 02:27:43.782] [PID=4712] [Csamcmanager52]: DoFlushIfNeeded: Failed to sync events to database: 0x80004005
Can any one revert on this ?
Solved! Go to Solution.
You may try using the following steps:
Open a CMD command window on the CSAMC50 server, and type :
- net stop csagent ( stop CSA agent )
- net stop crmdmgtd ( stop CiscoWorks )
- osql -E
backup log csamc50 with no_log
dbcc shrinkfile (csamc50_log)
- net start crmdmgtd ( start CiscoWorks )
- net start csagent ( Start CSA agent )
You didn't mention which SQL version you have or if it's local or remote.
Do you have SQL Studio Manager installed? It can also backup and shrink the db.
If not, you could try rrjoas45 suggestion but replace csamc50 with csamc52.
Back it up first though...
Thanks Tom for your posting
Q)You didn't mention which SQL version you have or if it's local or remote.
A)MS SQL Server 2000 ,Its Local Database.
B)SQL Studio manager is not installed
C)We are running CSAMC52
Should mssqladhelpder service should also get started,pls suggest.
I don't have the mssqladhelpder service running and it isn't an issue.
SQL Studio Manager should work for a SQL 2000 db.
More info here:
Try shrinking the db with it but back the system up before you try.
Still the error is repeating once I shrink the database .I should not install the SQL studio manager as I am a thrid party vendor.
Can you please suggest
Sorry, you've exhausted my vast (limited) SQL troubleshooting skills.
I suggest opening a TAC case or posting in a SQL forum.
Which commands do i use on CSA 5.0? i have search for osql tool on my this version but it is not present, i am running VMS 2.