<div>
Hi,<br />
<br />
Instance is like a new SQL Server in a OS, Every instance has different in name and have different set of rules.<br />
<br />
In any instance ,it contains many databases.
</div>


Hi,

Instance is like a new SQL Server in a OS, Every instance has different in name and have different set of rules.

In any instance ,it contains many databases.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
&nbsp; Its a bot confusing - whats the difference between a database and database instance in MS SQL?<br />
<br />
I have noticed on a single MS SQL server you can restore several databases. What then is an instance of db?<br />
<br />
Thanks
</div>
</div>


Hello,

  Its a bot confusing - whats the difference between a database and database instance in MS SQL?

I have noticed on a single MS SQL server you can restore several databases. What then is an instance of db?

Thanks

Difference between databases and database instance in MS SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.