SQL Server Performance Forum – Threads Archive
Restore Error
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
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.
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.
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.
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.
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.
Yes all the sql servers involved have the same sp (sp2 actually). Thanks
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.
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.
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.
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.
Here is the command: restore database mobileweb
from disk=’F:BACKUPmobileweb_backup_200705090200.bak’
with move ‘mobileweb_Data’ to ‘J
ATAmobileweb_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.
The database I’m trying to restore is about 40GB.
I tried with a database of 150 MB, it’s succeeded.
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.
]]>