Hi, I have looked and loked for the answer to this question and made no progress.
I want to install MSDE on one of our servers, however, when I went to install it, I found that there was another MSDE already installed and running (it was an agent running with our backup software Veritas). Is it alright to create another database and have 2 running simultaneous on the same data engine? Is there any type of limitations that I sould know about - such as number of allowed accesses at one time? Any help is greatly appreicated.You can create another database with the existing MSDE but if you are on a large network I would install another instance and get the Developer edition to manage them that way you will avoid the risk of running your application on MSDE that is already used to the max in system resources. I have seen SQL Server running without databases because it is used to run xp_cmdshell to move data from DB2 AS400 to live SQL Server on the web about four hours a day. Try the link below to buy the Developer edition. When you have installed the Developer edition you right click at the top of Enterprise manager and register both. Hope this helps.
http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment