?
Solved

SQL database full BE 12.5

Posted on 2009-05-11
2
Medium Priority
?
582 Views
Last Modified: 2013-12-01
When I try to edit a selection list ar job and save it I get an error:
native=0x451 source= Microsoft OLE DB Provider for SQL Server hr=0x80040e14 Could not allocate space for object 'DBO.BackupScriptEntries','cidx_BackupScriptEntries' in database BEDB because the 'Primary' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional file to the filegroup, or setting autogrowth on for existing files in the filegroup.
Help?
0
Comment
Question by:CCBIL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Expert Comment

by:Aanvik
ID: 24355671
Look for the Files.. Looks like either disc is full or file restriction has reached.


0
 
LVL 28

Accepted Solution

by:
honmapog earned 2000 total points
ID: 24358268
If your disk is not full, check the size of bedb_dat.mdf in the Program Files\Symantec\Backup Exec\Data directory.
Did you install Backup Exec in a full-blown SQL instance, or did you use SQL Express? If you're using SQL Express, the maximum size of the file is 2GB.

If the file is not near 2GB, check if you have quotas enabled on your system.

You may be able to grow the database with the ALTER DATABASE command.
Write down the size of your current bedb_dat.mdf file. Then add 20MB. Take that value as the new_size parameter in the following sequence of commands you run from the command line:

osql -E -S your_servername\BKUPEXEC
1> use bedb
2> ALTER DATABASE bedb MODIFY FILE (NAME=bedb_dat, SIZE=new_size)
3> go
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to fix error ""Failed to validate the vCentre certificate. Either install or verify the certificate by using the vSphere Data Protection Configuration utility" when you are trying to connect to VDP instance from Vcenter.
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question