Video Screencast Help

Datebase file bedb_dat.mdf and BEDB.bak over 4 Gigs

Created: 04 Nov 2013 | 8 comments

Hello I have two files that are both over 4 gigs each they are bedb_dat.mdf and BEDB.bak. I know these are the live database file and backup for backup exec. Is there any way to reduce the size of these files. I am running out of hard drive space.

I am running backup exec 2012 SP2 on windows server 2008 r2.

Operating Systems:

Comments 8 CommentsJump to latest comment

Colin Weaver's picture

Start with this

http://www.symantec.com/docs/TECH51462

Oh and when we add some text in a tech article indicating you should contact tech support we mean a formal support case

 

 

Vishal Shinde's picture

Hello ,

This issue is observed when the job details are enabled for the job logs.

this will cause "jobHistoryDetailInfo" table to fill up.

you may connect to the BEDB database, using osql and run the following commands:

osql -E -S (servername)\bkupexec - (where servername is the server that the BKUPEXEC instance is on)
Use BEDB (enter)
Select count(*) from JobHistoryDetailInfo (enter)
Go (enter)
Use BEDB (enter)
Truncate table JobHistoryDetailInfo (enter)
Go (enter)
Use BEDB (enter)
DBCC shrinkdatabase (BEDB) (enter)
Go (enter)

This will create enough space and reduce the size of the database.

Hope this helps!

Kind regards,

S

 

Vishal Shinde

Sr.Learning Consultant

Symantec Education Services

jeff.j's picture

Sasha2008 sorry I am not really fimilar with SQL where is osql?

Vishal Shinde's picture

Hi Jeff,

You can run the osql utility by typing osql at the Windows command prompt on Backup Exec Server with the switch -E and -S.

osql -E -S <servername>\bkupexec - (where servername is the server that the BKUPEXEC instance is on)
 

rest of the commands will be as above.

Regards,

S

Vishal Shinde

Sr.Learning Consultant

Symantec Education Services

jeff.j's picture

Sasha I tried the commands, they did not shrink the database.

VJware's picture

Check event viewer for database maintenance failures and see if its failing on audit logs or not. If yes, would recommend to log a formal support case.

Reference KB - http://www.symantec.com/business/support/index?pag...

Vishal Shinde's picture

Hello Jeff,

As VJWare has rightly pointed, please check the event viewer for the audit log issue.

This is a confirmed and documented issue,However the cause remains same, i.e outgrown size of the BEDB database , and the following tables outgrow in size commonly.

Alert
JobHistoryDetail
JobHistoryDetailInfo
JobHistorySummary

 

Additionally, I have made the changes in the SQL commands, this should take care of the problem.

 

this will involve running the osql utility by typing osql at the Windows command prompt on Backup Exec Server with the switch -E and -S.

osql -E -S <servername>\bkupexec - (where servername is the server that the BKUPEXEC instance is on)
 

(Step 1.)

use BEDB
go
truncate TABLE JobHistoryDetailInfo
go
select Count(*) from JobHistoryDetailInfo
go
-------------------------------------------------------------------------------------

(Step 2.)

use BEDB
go
truncate TABLE JobHistorySummary
go
select Count(*) from JobHistorySummary
go
----------------------------------------------------------------------------

(Step 3.)

use BEDB
go
truncate TABLE JobHistoryDetail
go
select Count(*) from JobHistoryDetail
go
-------------------------------------------------------------------------

(Step 4.)

use BEDB
go
truncate TABLE Alert
go
select Count(*) from Alert
go

(Step 5)

use BEDB
go
DBCC SHRINKDATABASE (BEDB,5)
go
------------------------------------------------------------------

Hope this helps!

Regards,
S

 

Vishal Shinde

Sr.Learning Consultant

Symantec Education Services

jeff.j's picture

I tried the new command you gave. Here is what I typed into CMD and what my results were

 

C:\Windows\system32>osql -E -S backexec\bkupexec
1> use BEDB
2> go
1> truncate TABLE JobHistoryDetailInfo
2> go
1> select Count(*) from JobHistoryDetailInfo
2> go

 -----------
           0

(1 row affected)
1> Use BEDB
2> go
1> truncate TABLE JobHistorySummary
2> go
1> select Count(*) from JobHistorySummary
2> go

 -----------
           0

(1 row affected)
1> use BEDB
2> go
1> truncate TABLE JobHistoryDetail
2> go
1> select Count(*) from JobHistoryDetail
2> go

 -----------
           0

(1 row affected)
1> use BEDB
2> go
1> truncate TABLE Alert
2> go
1> select Count(*) from Alert
2> go

 -----------
           0

(1 row affected)
1> use BEDB
2> go
1> DBCC SHRINKDATABASE (BEDB,5)
2> go
DBCC SHRINKDATABASE: File ID 1 of database ID 5 was skipped because the file
does not have enough free space to reclaim.
 DbId   FileId      CurrentSize MinimumSize UsedPages   EstimatedPages
 ------ ----------- ----------- ----------- ----------- --------------
      5           2         160         128         160            128

(1 row affected)
DBCC execution completed. If DBCC printed error messages, contact your system
administrator.
1>

I also checked my event logs and did find a Event ID 57348 "Database Maintenace Failure"

I have opened a case with Symantec and I am waiting to hear back.