How to restore a database from large sql file?
I have a 2 GB SQL file, generated from SQL Server database 2008, which includes data and schema. SQL Server 2008 Express does not even open the file saying an error:
Error: HRESULT E_FAIL has been returned from a call to a COM component
but, the file opens 开发者_Go百科in word pad while it just hangs after loading the file.
Any idea or suggestions what is the problem and how to overcome?
I experienced similar issue before, this is how I fixed it:
- Go to Control Panel -> Clock, Language, and Region -> Change location
- Change your location in the format tab to English (United States) and in the location tab change to United States.
Also please make sure that the Language for non-Unicode program
section that you can find inside the Administrative Tab
in the Change Location
section should be set to English (United States).
精彩评论