January 22, 2013 at 10:05 pm
Hello everyone,
Please let me know the difference between database and database instance.
Thank you.
January 22, 2013 at 10:17 pm
The following link would get you the answer to that question :
January 22, 2013 at 11:55 pm
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, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
January 23, 2013 at 12:02 am
Thank you
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy