Error restore backup (sql2000 on w2000 server)

Hi,
I want to restore a backup that we did in another
computer, the name is: CPlus.bak, when I click : Restore...
(I used restore 'from device:').. it issues this
message: "Device activation error. The physical file
name "F:\MSSQL\data\CPlus_Data.MDF" may be
incorrect.File 'CPlus_Data' cannot restored
to 'f:\MSSQL\data\CPlus_Data.MDF'...
...
File 'CPlus_Log' cannot be restored
to 'f:\MSSQL\data\CPlus_Log.LDF'....
give us a light!!!
tia,
AnaHi,
The folder F:\MSSQL\data\?exist, what is BOL.
Thanks,
Ana
>--Original Message--
>Does the new computer have the path F:\MSSQL\data\? If
not
>use "restore...with move" which can be found in BOL.
>>--Original Message--
>>Hi,
>>I want to restore a backup that we did in another
>>computer, the name is: CPlus.bak, when I click :
>Restore...
>>(I used restore 'from device:').. it issues this
>>message: "Device activation error. The physical file
>>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>>incorrect.File 'CPlus_Data' cannot restored
>>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>>....
>>File 'CPlus_Log' cannot be restored
>>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>>give us a light!!!
>>tia,
>>Ana
>>.
>.
>|||BOL = Books On Line . It should be found at Start>Programs>Microsoft SQL
Server>Books Online. Type Restore database into the index to find the syntax
for RESTORE DATABASE
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ana" <anonymous@.discussions.microsoft.com> wrote in message
news:02d801c3b2ab$1753b760$a101280a@.phx.gbl...
Hi,
The folder F:\MSSQL\data\?exist, what is BOL.
Thanks,
Ana
>--Original Message--
>Does the new computer have the path F:\MSSQL\data\? If
not
>use "restore...with move" which can be found in BOL.
>>--Original Message--
>>Hi,
>>I want to restore a backup that we did in another
>>computer, the name is: CPlus.bak, when I click :
>Restore...
>>(I used restore 'from device:').. it issues this
>>message: "Device activation error. The physical file
>>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>>incorrect.File 'CPlus_Data' cannot restored
>>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>>....
>>File 'CPlus_Log' cannot be restored
>>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>>give us a light!!!
>>tia,
>>Ana
>>.
>.
>|||SQL Server Books Online.
>--Original Message--
>Hi,
>The folder F:\MSSQL\data\?exist, what is BOL.
>Thanks,
>Ana
>>--Original Message--
>>Does the new computer have the path F:\MSSQL\data\? If
>not
>>use "restore...with move" which can be found in BOL.
>>--Original Message--
>>Hi,
>>I want to restore a backup that we did in another
>>computer, the name is: CPlus.bak, when I click :
>>Restore...
>>(I used restore 'from device:').. it issues this
>>message: "Device activation error. The physical file
>>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>>incorrect.File 'CPlus_Data' cannot restored
>>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>>....
>>File 'CPlus_Log' cannot be restored
>>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>>give us a light!!!
>>tia,
>>Ana
>>.
>>.
>.
>|||Does the new computer have the path F:\MSSQL\data\? If not
use "restore...with move" which can be found in BOL.
>--Original Message--
>Hi,
>I want to restore a backup that we did in another
>computer, the name is: CPlus.bak, when I click :
Restore...
>(I used restore 'from device:').. it issues this
>message: "Device activation error. The physical file
>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>incorrect.File 'CPlus_Data' cannot restored
>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>....
>File 'CPlus_Log' cannot be restored
>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>give us a light!!!
>tia,
>Ana
>.
>

error pending file

I've uninstall my previous sql2000 developer edition with leave some dll file undeleted.

once I tried to reinstall the sqlserver, the installation setup stop the process with message: A previous installation created pending file operations on the installation machine.
you must restart the computer before running setup.

I fail in continueing setup although i've restart the pc.

What should i do to handle this?

Regards,

BHT

Hhh.... please someone help me...

I don't want to reinstall the O/S as previously i've done. headache and waisting my days.

Regards,

BHT

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b312995&Product=sql

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

At last I saved. Thank you for your help.

Trully it is very suffer when become a begginer. (

Regards,

BHT

Error on SP2 SQL2000 RS

An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
a.. Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
How do I fix this? The log entry looks like:
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing encryption
key
w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to GetSystemPermissions
w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
GetPermissions:/Lockout
w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to GetSystemPermissions
w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
GetPermissions:/Lockout/NTLM Lockout Trending Weekly
w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to GetSystemPermissions
w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not
specified in Server system properties.
w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
System.TypeLoadException: Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.TypeLoadException: Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --Strange. Are you running SP2? The only thing I can think of is to clear our
your ASP.NET temporary files folder
(C:\windows\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files).
Also, be sure you only have one version of the Interfaces assembly around.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"almoendale" <no_spam@.nowhere.net> wrote in message
news:urkNxU%23fFHA.3232@.TK2MSFTNGP15.phx.gbl...
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help
> a.. Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> How do I fix this? The log entry looks like:
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing
> encryption key
> w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
> GetPermissions:/Lockout
> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
> GetPermissions:/Lockout/NTLM Lockout Trending Weekly
> w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
> EnableIntegratedSecurity to 'True' as specified in Server system
> properties.
> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
> ResponseBufferSizeKb to default value of '64' KB because it was not
> specified in Server system properties.
> w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
> System.TypeLoadException: Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.TypeLoadException: Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
>|||Brian:
I cleared out the ASP.net temp folder, no success. I have RS SP2 (do
*not* have W2K3 SP1), have attempted to re-apply RS SP2, which didn't help.
I am getting errors out of other web parts too on this WSS site (SP1 there
BTW). This box is a rather old dev crash box that may well need to be
rebuilt. it has everything but the kitchen sink so to speak: (Project
Server03, WSS, SQL RS, Maestro Beta, numerous custom web parts, etc.) Wish I
could just roll it back to about 2 weeks back when everything was working
ducky.
Interestingly the Samples all fail too.
I guess what bothers me most is the cryptic (bullet with a question
mark) nature of the error display:
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error
log for more details. (rsInternalError) Get Online Help
a.. ?
----
Microsoft Reporting Services
Alex
======================================================
Explanation
Internal errors are uncommon and may be difficult to diagnose. If you
get this error, you can look in trace logs for more information.
Note that if you renamed the computer that hosts the report server,
you may encounter internal errors related to the name change (specifically,
"A severe error occurred on the current command" error or "RPC server is not
listening"). If you renamed the computer, you can run the rsconfig utility
to update the system information that is stored by the report server.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:urZJNJAgFHA.3584@.TK2MSFTNGP09.phx.gbl...
> Strange. Are you running SP2? The only thing I can think of is to clear
> our your ASP.NET temporary files folder
> (C:\windows\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files).
> Also, be sure you only have one version of the Interfaces assembly around.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "almoendale" <no_spam@.nowhere.net> wrote in message
> news:urkNxU%23fFHA.3232@.TK2MSFTNGP15.phx.gbl...
>> An internal error occurred on the report server. See the error log for
>> more details. (rsInternalError) Get Online Help
>> a.. Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> How do I fix this? The log entry looks like:
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as
>> user: NT AUTHORITY\NETWORK SERVICE
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing
>> encryption key
>> w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
>> GetPermissions:/Lockout
>> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
>> GetPermissions:/Lockout/NTLM Lockout Trending Weekly
>> w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
>> EnableIntegratedSecurity to 'True' as specified in Server system
>> properties.
>> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
>> ResponseBufferSizeKb to default value of '64' KB because it was not
>> specified in Server system properties.
>> w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
>> System.TypeLoadException: Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> streamFactory)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> itemType)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., ;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.TypeLoadException: Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> streamFactory)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> itemType)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> -- End of inner exception stack trace --
>>
>sql

Error Msg 701(on sql2000)no insufficient system memory to run q

Hi.
When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
line number varies).
To solve this problem, I setupped sq4(the exe file name is
SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
And then I tried to run this procedure again: Statistic_R401, but the server
still told me this error.
The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
is Win2003 Enterprise.
If I wont upgrade the hardware, how will I solve it? Thank you!
yangHi,
You have very less amount of memory in you server. Probaly some other
program would have taken all the memory. Just verify the memory usage.
I suggest you to make the SQL Server memory to 350 MB and restart the SQL
Server and see.
My recommendation is try increasing the RAM to 1 GB..
Thanks
Hari
"faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
> Hi.
> When I ran a procedure in sql2000, I hit this problem: Error Msg
> 701,Level
> 17,State 106,the procedure Statistic_R401(the procedure's name),line
> 37(the
> line number varies).
> To solve this problem, I setupped sq4(the exe file name is
> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039
> now.
> And then I tried to run this procedure again: Statistic_R401, but the
> server
> still told me this error.
> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
> is Win2003 Enterprise.
> If I wont upgrade the hardware, how will I solve it? Thank you!
> yang|||Also, it might be worth to check if someone has fiddled with the sp_configure settings.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23hA9ro1FHHA.4804@.TK2MSFTNGP03.phx.gbl...
> Hi,
> You have very less amount of memory in you server. Probaly some other program would have taken all
> the memory. Just verify the memory usage.
> I suggest you to make the SQL Server memory to 350 MB and restart the SQL Server and see.
> My recommendation is try increasing the RAM to 1 GB..
> Thanks
> Hari
> "faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
> news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
>> Hi.
>> When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
>> 17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
>> line number varies).
>> To solve this problem, I setupped sq4(the exe file name is
>> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
>> And then I tried to run this procedure again: Statistic_R401, but the server
>> still told me this error.
>> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
>> is Win2003 Enterprise.
>> If I wont upgrade the hardware, how will I solve it? Thank you!
>> yang
>

Error Msg 701(on sql2000)no insufficient system memory to run q

Hi.
When I ran a procedure in sql2000, I hit this problem: Error Msg 701,Level
17,State 106,the procedure Statistic_R401(the procedure's name),line 37(the
line number varies).
To solve this problem, I setupped sq4(the exe file name is
SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039 now.
And then I tried to run this procedure again: Statistic_R401, but the server
still told me this error.
The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
is Win2003 Enterprise.
If I wont upgrade the hardware, how will I solve it? Thank you!
yangHi,
You have very less amount of memory in you server. Probaly some other
program would have taken all the memory. Just verify the memory usage.
I suggest you to make the SQL Server memory to 350 MB and restart the SQL
Server and see.
My recommendation is try increasing the RAM to 1 GB..
Thanks
Hari
"faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
> Hi.
> When I ran a procedure in sql2000, I hit this problem: Error Msg
> 701,Level
> 17,State 106,the procedure Statistic_R401(the procedure's name),line
> 37(the
> line number varies).
> To solve this problem, I setupped sq4(the exe file name is
> SQL2000-KB884525-SP4-x86-CHS.EXE), so the QD verison becomes 8.00.2039
> now.
> And then I tried to run this procedure again: Statistic_R401, but the
> server
> still told me this error.
> The server is a 2.40GHz Intel (R) Pentium (R) 4 CPU with 512Mb RAM. The OS
> is Win2003 Enterprise.
> If I wont upgrade the hardware, how will I solve it? Thank you!
> yang|||Also, it might be worth to check if someone has fiddled with the sp_configur
e settings.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23hA9ro1FHHA.4804@.TK2MSFTNGP03.phx.gbl...
> Hi,
> You have very less amount of memory in you server. Probaly some other prog
ram would have taken all
> the memory. Just verify the memory usage.
> I suggest you to make the SQL Server memory to 350 MB and restart the SQL
Server and see.
> My recommendation is try increasing the RAM to 1 GB..
> Thanks
> Hari
> "faithdiffla" <faithdiffla@.discussions.microsoft.com> wrote in message
> news:111E8747-887C-472C-A446-85EFDDEF7D6B@.microsoft.com...
>