Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

what is difference between database and database instance Expand / Collapse
Author
Message
Posted Tuesday, January 22, 2013 10:05 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 2:16 AM
Points: 27, Visits: 267
Hello everyone,

Please let me know the difference between database and database instance.

Thank you.
Post #1410338
Posted Tuesday, January 22, 2013 10:17 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 11:44 AM
Points: 1,127, Visits: 1,592
The following link would get you the answer to that question :

Difference between Database and Database Instance


Vinu Vijayan

For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden
Post #1410341
Posted Tuesday, January 22, 2013 11:55 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:50 AM
Points: 517, Visits: 346
First of all, you need to be aware of the difference between database instance and SQL Server instance - both frequently referred to as just "instance" - a cause much confusion on a regular basis.

The term database instance is most frequently used in connection with Oracle. Basically, a database is what's written in physical files on disk, while an instance is what runs in memory on a specific computer at a specific time. Your database instance exists only temporarily - it will disappear completely if you shut down your computer, stop the related service or detach the database. But the database itself should never be in any danger of disappearing permanently - making sure of that is your number one job as a DBA.

Now, as I mentioned, the term database instance is most commonly used in relation to Oracle.
When we talk about an instance, we usually mean a SQL Server instance, which is a specific installation of SQL Server. When people are not aware of these things, it can cause a lot of confusion and a lot of waste as people go about installing new SQL Server instances where really all they need is a new database.




Vegard Hagen
Norwegian DBA, blogger and generally a nice guy who believes the world is big enough for all of us.

@vegard_hagen on Twitter
Blog: Vegard's corner (No actual SQL stuff here - haven't found my niche yet. Maybe some day...)

"It is better to light a candle than to curse the darkness."
(Chinese proverb)

Post #1410360
Posted Wednesday, January 23, 2013 12:02 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 2:16 AM
Points: 27, Visits: 267
Thank you
Post #1410363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse