SQL 2005 with running 2 Databases

5 pts.
Tags:
SQL Server 2005
Can we install one instance of SQL 2005 on one server but running two different databases?
ASKED: February 18, 2008  4:18 PM
UPDATED: February 18, 2008  9:04 PM

Answer Wiki

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

Absolutely! The default installation usually contains as examples multiple databases (i.e. Northwinds).

SQL Server 2005 can support several thousand databases per server so long as you have enough storage, RAM, CPU power and disk capacity.

Discuss This Question: 1  Reply

 
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
  • Buddyfarr
    Yes, as Lbracamo65 has said you can do this with as many databases as you wish. The license of SQL server is for the install only, not the number of databases you run on it. The only limiting factors would be: 1) how large do you think these databases will grow. 2) amount of ram in the server 3) amount of storage in server 4) number of concurrently connected users to each database you can still run multiple databases but any of the above will affect how well they run on the server and the impact each has on the end users.
    6,850 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