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 |
|
alw74
Starting Member
1 Post |
 Posted - 2007-11-08 : 04:42:49
|
| Hi there,I'm new to this forum but was wondering if you could advise me on getting the DB back to an accessible state. I tried restoring the DB but unfortunately I don't have enough disk space. The error message appeared instantly informing me of the lack of disk space. Now it says its in (Loading state) and I cannot access the DB. Is there anyway I can manually change it back?? |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-08 : 07:31:39
|
| Are you using sql server 2005??RKNAIR |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-08 : 15:52:04
|
| Run 'restore database db_name with recovery', but don't think the db is usable. Find bigger disk and restore it there. |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-11-08 : 15:59:00
|
| You'll have to issue a DROP DATABASE as the restore failed to complete. I doubt you'll even be able to bring it online with a recovery restore at this point. |
|
|
|
|
|
|
Stuck in loading state while restoring DB