Hi everybody
Help me, Help me.
When I backup the MSSQL databases using ARCServe 2000 in the server, the memory of sqlserver.exe is 1.5G in task manager. After backup was finished, the memory of sqlserver.exe cannot released. It is still 1.5G. Our users can get the resource of that server but they get it slowly. I need to stop and restart the MSSQL service. The server can back to normal.
Can everyone fix it ?
My server is
Windows 2000 Server Standard Edition with SP4
Windows SQL 2000 Standard Edition With SP3
Memory is 2G RAM
Pls Help.
ThanksDo you want to stop and restart (http://msdn2.microsoft.com/en-us/library/ms187598.aspx) SQL Server from a script?
-PatP|||PatP
Thank you for your reply
I got a one problem. I must need to restart the service using password because this is security reason. So, how to write a script with password|||Hi Everybody
I want to reinstall ARCserve 2000 on the server but I lost the license key.
I cannot register it. Can I get or export or read the license key / serial number on existing ARCserve 2000 of server for reinstallation ?
Thank you|||You don't need a password to stop or restart SQL Server. If you are using a Windows Service login, then the password is stored by the service itself. If you need to run the script as a machine administrator, then that password needs to be stored with the Windows Task description. You don't need to code the password into the script, that's a very bad idea and should be avoided.
-PatP|||could the problem be on the arcserv end. i do not know arcserv, but i am wondering if it is leaving connections open or something like that. have you tried opening up profiler to see what is going on?|||Hi Pat
Thanks
A applications is running with connecting the SQL server on that server. If the sql service is restarted, I need to provide two passwords for application to run it. Although the sql service can use the script automatically, the application on that server need to be ran manually every time.
No comments:
Post a Comment