An occurrence of a database component. This can mean very different things depending on the platform.
0
votes
2answers
41 views
Multiple instances in Oracle
I'm really confuse with the term instance and database. So, my first question is how database and Instance are related in Oracle, I mean, whether an instance is associated with one/multiple ...
1
vote
1answer
159 views
How to drop a DB2 instance when the instance owner was removed
This is a real sticky situation. I was handed over a machine (running an AIX 7.1), and my first task was to re-install DB2 server on it. But someone before me had conveniently removed an instance ...
10
votes
2answers
201 views
What is shared between two instances on the same server?
We want to install multiple instances of SQL Server on a single Windows server. We cannot use VMs because the server is bare metal Windows 2008 R2.
For security purposes we need to ensure that the ...
19
votes
3answers
3k views
Is the SQL Server Express memory and CPU limit per instance?
If I have 8GB of RAM in a server and I run 4 instances of SQL Server Express, will the total memory limit used by SQL Server be 1GB or 4GB?
Would it be advisable to run multiple instances like this ...
4
votes
1answer
132 views
When should startup parameter -E be used?
We are starting to build a data warehouse system using SQL Server 2008 R2. One of the senior DBAs told us to consider using a startup parameter -E for the SQL Server service. I read from Books Online ...
3
votes
4answers
365 views
Is it advantageous to scale out using multiple SQL Server instances on the same server?
For a use-case of 9 databases spread across 3 time zones, is it advantagous to spread the databases onto multiple SQL Server instances on the same server?
What will I gain and what will I lose? ...
1
vote
3answers
230 views
Instance Startup Modes & Shutdown Modes
So, I know that there are 3 modes of startup modes available for the instance which is NOMOUNT, MOUNT, and OPEN.
What I want to know is in NOMOUNT mode it is stated that the instance started but still ...
1
vote
1answer
71 views
Node and Instance Relationship on Oracle RAC
I'd like to ask about the process of Node and Instance on Oracle RAC functionality.
I know that RAC provides Failover, a RAC feature that keeps an application running even if the node that was ...
3
votes
1answer
133 views
Connecting to an SQL server instance without using square brackets to avoid backslash
In our company we have an old piece of software which was written by our previous I.T manager but was never finished.
The program connects to SQL server but we want it to point to a newer SQL server ...
5
votes
3answers
1k views
Upstart script in ubuntu for mongodb
I am new to linux and mongodb.
I've already installed mongodb on ubuntu but I want to run one more instance on different port.
As I understood from other questions and forums , there must be upstart ...
0
votes
2answers
137 views
Concat issue has me perplexed
MSSQL 2005 Server Workgroup.
I have a database that is serving as a "Warehouse" for another, older, slower cobol database/application.
I've recently moved the warehouse from one SQL Server instance ...
3
votes
2answers
746 views
Create unique DB_NAME and DB_DOMAIN for an Oracle 11g instance
I am somewhat confused by these terms in the init.ora file:
db_domain
db_name
instance_name
plus the database name which is provided to the create database command. I do not completely understand ...
4
votes
3answers
4k views
SQL Server 2008 R2: Problems after computer name change
I'm having a confusing problem after changing the computer name of a remote server hosting a local SQL Server instance.
Basically, a remote server was moved from one site to another. In order to ...
1
vote
2answers
1k views
Installing SQL Server Express instance so common users can access
I need to install a SQL Server Express instance (as an admin) which can be later on read and modified by regular users.
I run into http://msdn.microsoft.com/en-us/library/ms254504.aspx, and I'm ...
2
votes
1answer
343 views
SQL Server 2008 R2 - Upgrade Default DB Instance (Express) to Developer Edition
I have just installed SQL Server 2008 R2 Developer edition (created a new instance for it: DEVEDITION). I previously had and the default instance (MSSQLSERVER) which was running SQL Server 2008 R2 ...
3
votes
1answer
100 views
Why SQL Server installs multiple services for AS and RS, but only one for IS?
When I install multiple SQL Server instances on a same computer, every instance gets its own SQL Server Service for Analysis Services and Reporting Services. But I get only one service for Integration ...
2
votes
1answer
449 views
How to disable instance recovery in ORACLE?
I want my DB to stop instance recovery during opening, how to do it?
I want it because it crashes when trying to do instance recovery, I am testing some cases and want to disable it
Is there any ...
1
vote
2answers
245 views
Assigning a logical name to a sql instance
How can we assign a logical name to a sql instance please? We would need to as to property identify messages coming through from the server.
Update
Thanks much for your replies. Yes it is for the ...
5
votes
3answers
219 views
For Oracle, we mount the instance to the database or mount the database to the instance?
The following text is extract from oracle documentation.
Start the instance, and mount and open
the database. This can be done in
unrestricted mode, allowing access to
all users, or in ...
0
votes
2answers
721 views
How to make inter-database queries with dynamic SQL Server database name?
We have two database servers with SQL Server 2005, with two databases each. The secondary server have two SQL Server instances: one for development and other for reporting. Both instances on secondary ...
10
votes
3answers
527 views
What's the most effective way to duplicate an instance on SQL 2008?
We've got a simple database instance with just enough data in the databases to keep it useful, and we can use it for demonstration purposes, and I want to put a copy of it on my laptop so I can use it ...
11
votes
2answers
3k views
How do I change the instance name in MS SQL 2005 without installing a new instance?
I have an instance that really has nothing on it, it's merely been installed (it was intended for one project, but that never actually got done on this server, the project was done in duplicate on ...
