SQL Server 2008 Restore error message

Tags:
SQL Server
SQL Server 2003
SQL Server 2005
SQL Server 2008 error messages
SQL Server restore
I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’"
Anyone have any ideas?


Software/Hardware used:
SQL Server 2005, Server 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.

I experienced this problem earlier when I worked in Windows XP and Sql Server 2008. Now I am using Suse Linux Ent Server 11 and Oradcle 10G. I put here the detailed information and solutions what I did this time. Plz read it very minutely and apply as per ur desire. Before do anything, it is good practice to take full back up of ur database.

* You are running the following versions of SQL Server Management Studio:

1.The release version of SQL Server 2008 Management Studio, version 10.00.1806 to 10.00.1813
Note For example, you install SQL Server 2008 Cumulative Update 5, and the version of Management Studio is 10.00.1806.
2. SQL Server 2008 Service Pack 1 (SP1) Management Studio, version 10.00.2714 to 10.00.2725
Note For example, you install SQL Server 2008 SP1 Cumulative Update 2, and the version of Management Studio is 10.00.2714.
3. You use one of these versions of SQL Server Management Studio to connect to a SQL Server 2000 instance.
4. You perform a backup operation on a database in the SQL Server 2000 instance.
5. In SQL Server Management Studio, you right-click the database to perform a restore operation in this SQL Server 2008 instance.

To resolve this problem, use the following table to find the appropriate method for your version of SQL Server.
SQL Server release Cumulative update Resolution
(version of SQL Server)

The release version 10.00.1806 to 10.00.1813 Apply the individual hotfix for the
of SQL Server 2008 release version of SQL Server 2008.
To obtain this hotfix, refer to the
“Hotfix information” section in this
article. Or, apply SQL Server 2008
Cumulative update package 7

SQL Server 2008 SP1 10.00.2714 to 10.00.2725 Apply the individual hotfix for the SQL
Server 2008 Service Pack 1. To obtain
this hotfix, refer to the “Hotfix
information” section in this article. Or,
Apply SQL Server 2008 Service Pack 1
Cumulative update package 4.

Cumulative update information:

1. SQL Server 2008, Important You must use this fix if you are running the release version of
SQL Server 2008.

Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. I recommend that you consider applying the most recent fix release that contains this hotfix.

2. The SQL Server 2008 builds that were released after SQL Server 2008 was released
SQL Server 2008 Service Pack 1

Important You must use this fix if you are running SQL Server 2008 Service Pack 1.

Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix.
The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released Microsoft SQL Server 2008 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2008 Service Pack 1 hotfix to an installation of SQL Server 2008 Service Pack 1. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.

Hotfix information for SQL Server 2008 Service Pack 1
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a “Hotfix download available” If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note The “Hotfix download available” form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.
Prerequisites:-
You must have SQL Server 2008 Service Pack 1 installed before you apply this hotfix.
Restart information, You do not have to restart the computer after you apply this hotfix.
Registry information, You do not have to change the registry. Hotfix file information
This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain all the files that you must have to fully update a product to the latest build.

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

For 32-bit version:-

SQL Server 2008 Database Services Core Shared Collapse this tableExpand this table

File name File File size Date Time Platform
version
Commanddest.dll 2007.100.2727.0 164,712 13-Aug-2009 03:01 X86
Datacollectorenumerators.dll 2007.100.2727.0 69,464 13-Aug-2009 03:03 x86
Distrib.exe 2007.100.2727.0 75,096 13-Aug-2009 03:19 x86
Dtspipeline.dll 2007.100.2727.0 694,104 13-Aug-2009 03:19 x86
Dtswizard.exe 2007.100.2727.0 804,712 13-Aug-2009 03:19 x86
Exceldest.dll 2007.100.2727.0 173,400 13-Aug-2009 03:35 x86
Excelsrc.dll 2007.100.2727.0 183,128 13-Aug-2009 03:35 x86
Flatfiledest.dll 2007.100.2727.0 276,312 13-Aug-2009 03:36 x86
Flatfilesrc.dll 2007.100.2727.0 283,992 13-Aug-2009 03:36 x86
Iftsph.dll 2007.100.2727.0 38,248 13-Aug-2009 03:52 x86
Logread.exe 2007.100.2727.0 423,256 13-Aug-2009 04:33 x86
Microsoft.sqlserver.dmf.dll 10.0.2727.0 296,792 13-Aug-2009 04:39 x86
Microsoft.sqlserver.pipelinehost.dll 10.0.2727.0 71,512 13-Aug-2009 04:42 x86
Microsoft.sqlserver.sqlenum.dll 10.0.2727.0 1,083,224 13-Aug-2009 04:42 x86
Oledbdest.dll 2007.100.2727.0 173,912 13-Aug-2009 04:52 x86
Oledbsrc.dll 2007.100.2727.0 186,728 13-Aug-2009 04:52 x86
Rdistcom.dll 2007.100.2727.0 651,112 13-Aug-2009 05:09 x86
Repldp.dll 2007.100.2727.0 191,336 13-Aug-2009 05:10 x86
Replmerg.exe 2007.100.2727.0 341,352 13-Aug-2009 05:10 x86
Snapshot.exe 10.0.2727.0 13,144 13-Aug-2009 06:18 x86
Sql_engine_core_shared_keyfile.dll 2007.100.2727.0 13,656 13-Aug-2009 04:19 x86
Sqllogship.exe 10.0.2727.0 96,104 13-Aug-2009 06:19 x86
Sqlmergx.dll 2007.100.2727.0 192,856 13-Aug-2009 06:19 x86
Sqltaskconnections.dll 2007.100.2727.0 113,496 13-Aug-2009 06:20 x86
Txdataconvert.dll 2007.100.2727.0 206,696 13-Aug-2009 06:24 x86

To work around this problem, use one of the following methods:-

Method 1

Use Transact-SQL statements to restore the database. For example, you can use the following command to restore a database:

restore database Database Name from disk = ‘Backup file’

Method 2

To restore the database by using SQL Server Management Studio, following these steps:

1. Do not right-click the database. Instead, right-click the Database node, and then click Restore Database.
2. Do not select the From database option under Source for restore. Instead, select the From device option.
3. Follow the instructions to complete the restore operation.

To know whether the version of SQL Server Management Studio that is installed on your computer is affected by this problem,
check whether the version of the Microsoft.SqlServer.SqlEnum.dll file matches one of the affected versions in the “Symptoms”section. Generally,the Microsoft.SqlServer.SqlEnum.dll file is in one of the following folders, depending on whether SQL Server is installed by using Windows on Windows (WOW) mode.

SQL Server 2008

drive:\Program Files\Microsoft SQL Server\100\SDK\Assemblies
drive:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    What are the specs of the SQL Server? Memory settings, load on the system, etc.
    66,070 pointsBadges:
    report
  • Kmmc112233445566
    [...] New member Kmmc112233445566 kept receiving a SQL Server 2008 restore error message, and luckily Rechil has encountered the same error and could pitch [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following