what is difference between database and database instance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » what is difference between database and...

what is difference between database and database instance

Rate Topic

Display Mode

Topic Options

Author

Message

Rocky's

Posted Tuesday, January 22, 2013 10:05 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 26, Visits: 223

Hello everyone,

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

Thank you.

Post #1410338

vinu512

Posted Tuesday, January 22, 2013 10:17 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:37 AM
Points: 1,047, Visits: 1,439

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 Wink

Post #1410341

Vegard Hagen

Posted Tuesday, January 22, 2013 11:55 PM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:41 PM
Points: 494, Visits: 325

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

Rocky's

Posted Wednesday, January 23, 2013 12:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 26, Visits: 223

Thank you

Post #1410363

« Prev Topic | Next Topic »

Permissions