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 |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-08-17 : 06:10:58
|
| Hi allwhen i try to restore a database called ddaa, i am getting the following message after the restore is completed.. and the database icon in the enterprize manager is having ddaa(loading).now i am not able to access that database..the message i am getting is..database msdb cannot be opened due to anaccessible files or insufficient memory or disk space. could not insert a backup/restore history detail record in the msdb database.this may indicate a problem with the msdb database.how to resolve this issue..Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-17 : 06:38:47
|
| How much disk space do you have left?Peter LarssonHelsingborg, Sweden |
 |
|
|
sreehari
Starting Member
37 Posts |
Posted - 2006-08-17 : 06:55:04
|
| Thanks for quick reply.. The msdb datasbase is in D drive with 4GB of space left. The msdb database in EM has been marked as msdb(Suspect). The database which i tried to restore has been marked as dbaa(Loading)..Pls suggest me how to proceed..Thanks |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-08-17 : 11:24:42
|
| How much space is left in MSDB? When was the last time you ran CHECKDB on MSDB?I suspect you've either run out of space in MSDB (i.e. you don't have autogrow on) or MSDB is corrupt in some way.(I won't follow-up on this thread as I'm going on vacation for a week in a couple of hours)Paul RandalLead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
Issue with msdb database