mercredi 25 mars 2015

Need help timeout expired when restoring database using SQL Server 2005 Management Studio

Here's my script:



RESTORE DATABASE [database 2.2] <br>
FROM DISK = N'F:\database Backup\database Backup 20.Mar.2015\database2.2.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO


result:



10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.



Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Msg -2, Level 11, State 0, Line 0

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.



Please help I need to restore my database. I am using SQL Server 2005 Management Studio.


Thanks


Aucun commentaire:

Enregistrer un commentaire