Post reply

Database restore problem?

  • July 5, 2005 at 1:38 pm

    #109926

    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

    #571003

    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

    #571009

    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

    #571016

    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