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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-09-06 : 22:42:16
|
| The database backup failed with the following error.Any suggestions are greatly appreaciated[red]"Could not allaocte space for object dbo.backupfile'PK_backupfile_7B264621' in database 'msdb'because the PRIMARY filegroup is full.Create disk space by deleting unneeded files , droppping objects in the filrgroup, addindg additional files to the filegroup or setting autogrowth on for existing files in the filegroup."Thanks,Thaniparthi |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-09-07 : 05:19:05
|
| AS it says, the MSDB database is full.Check the size of the file, see if it's allowed to autogrow. If so, see if there's space available on the disk. If the file is not set to autogrow, then make the file larger (from database properties in management studio is easiest). If there's no space on the disk then you'll need to free up some space on the disk, or look at moving MSDB to a drive with more space.Other option is to delete some of your backup and/or job history. You can do that from the SQL Agent node in object explorer (history node)--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
backup failed