SQL Server Performance

Restore Error

Discussion in 'SQL Server 2005 General DBA Questions' started by ndobs, Apr 26, 2007.

  1. ndobs New Member


    Hello,

    I'm having a problem during the restore process of a database of 80GB size.
    Here the error message, it's a sql server 2005 SP2:


    ============================================================
    Restore failed for Server 'SQL7'. (Microsoft.SqlServer.Smo)


    Program Location:

    at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
    at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()


    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)[/red]

    ================================================================

    Could anyone help?

    Thanks.

    ndoba
  2. Luis Martin Moderator

    Is a 2005 backup?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

    Are you trying to restore from any other program, have you use SSMS or Query editor to restore?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. ndobs New Member

    It's a sql server 2005 backup.I'm not using another program.
    I've tried on SSMS and on query editor, I have the same error.


    Thanks.
  5. MohammedU New Member

    Some times you don't get the correct restore failure error in SSMS error window...
    So check the sql error log for more details about this restore failure.
    And also try to run the restore command in query window...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  6. satya Moderator

    Are the SQL servers (involvedin this backup) have similar service packs?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. ndobs New Member


    Yes all the sql servers involved have the same sp (sp2 actually).

    Thanks
  8. satya Moderator

    Are you trying from SSMS tool or a query editor?
    Check under event viewer for any hardware issues information, I feel this is a general issue when you try from SSMS where the clien't machine is already stressed with resource issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  9. ndobs New Member

    I used both, SSMS and the query editor, still i've got the same error.
    I reinstalled sql server on that server, but i have the same problem.

    Thanks for your help.
  10. MohammedU New Member

    1. Please post your restore command, I know it is simple but let us take a look...

    2. What edition of SQL server are you using?

    3. Are you running the restore command from your machine or from the server? If you are running from your machine, make sure remote connections are enabled through SAC.

    4. where is the backup file location? if it is network drive or shared drive copy backup file to local....


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  11. satya Moderator

    If this is a fresh server you may want to check the load on the production server with PerfMon
    and perhaps Profiler to see what's going on. I suggest checking the the SQL Server instance that you need to restore this database and also data source for the SQL Server Event Provider. Also check the timeout properties on the server.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  12. ndobs New Member

    Here is the command:

    restore database mobileweb
    from disk='F:BACKUPmobileweb_backup_200705090200.bak'
    with move 'mobileweb_Data' to 'J:DATAmobileweb_data.mdf',
    move 'mobileweb_log' to 'K:LOGmobileweb_log.ldf'


    The server whrere i want to restore is a fresh server, it's not
    on production yet.
    I connect to the server via remote desktop and run the command.
  13. ndobs New Member

    The database I'm trying to restore is about 40GB.
    I tried with a database of 150 MB, it's succeeded.

  14. satya Moderator

    Then can you ensure there is enough space on J & K drive for this 40gb database.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page