July 5, 2005 at 1:38 pm
Hello All,
I am getting problem in restore database,
when i was restoring database,i got message "there is not enough space for logs"
and i clicked ok, and since then database is showing offgrey and (loading) message on it.
when i try to right click on it , it doesn't allow me to do anything and give message
"restore is in the middle of process"
Please suggest me what should i do.
even i can't even drop that database .
I'm in big problem. i'm waiting to see normal database for 3 hr.
please help me.
Thanks in advance.
July 5, 2005 at 2:00 pm
The database will show a still loading in EM beacuse the SQL Server was unable to complete the restore operation due to the alck of space.
If first ensure that you have enough space on the server in question and then just restore the database again it will be fine as long as you have enough space this time.
hth
Dave
July 5, 2005 at 2:08 pm
Before i started restore i had 9 Gb space, including the existing database the one i want to restore.now still i have 9 Gb free space,first i want delete the loading database to free some space.how can i drop that database.please advise me.
Thanks
July 5, 2005 at 2:17 pm
sp_resetstatus database_name
this should reset the status of the database and allow you to delete it
hth
Dave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply