Questions tagged [instance]

An occurrence of a database component. This can mean very different things depending on the platform.

Filter by
Sorted by
Tagged with
0 votes
1 answer
12 views

MariaDB: How to install a second instance using MSI-Installer

I would like to install a second instance of MariaDB with MSI-Installer (Windows 10). The first instance is on drive C. When I want to install the second instance on drive D using MSI-Installer the ...
user avatar
  • 257
0 votes
1 answer
32 views

db2 - What is purpose of db2ln and its file system symbolic links?

On Linux/x86-64 I have Db2 v11.1 installed. When I tried to install Db2 v11.5 alongside existing Db2 installation I got error "DBI1004W /usr/lib/libdb2.so detected". I checked and I see ...
user avatar
  • 97
0 votes
0 answers
74 views

Multiple SQL instances on the same server and how to manage TempDB

Probably a bizarre approach but I don't really have much say in the setup. We have a large server deployed in Azure and the plan is to get 16 separate instances on this machine. We plan on using the ...
user avatar
  • 111
0 votes
1 answer
20 views

How to start second MySQL instance on boot on Ubuntu 20.04?

I have a second MySQL 8 instance running on Ubunut 20.04, started by this command: mysqld_safe --defaults-file=/home/user/mysqld_replica.cnf & The config file contains all needed settings like ...
user avatar
  • 283
2 votes
2 answers
211 views

Multiple instance properties

I'd like to understand how tuning works on instances that are living inside the same machine/VM. I couldn't find a straight answer to the question if properties of each separate instance have some ...
user avatar
0 votes
1 answer
95 views

Migrate from Standalone Instance to Failover Node Instance

I am fairly new to the MS SQL and i am currently working on a project at my company. We have a ERP System built on a SQL Server and we want to create a SQL failover node. The original configuration is ...
user avatar
7 votes
4 answers
2k views

Trick to remember which instance I am working with

I work as a BI developer and always switch between different instances on a same server. However, sometimes I forget the right instance and for example may cause to truncate a table on the other. I ...
user avatar
1 vote
2 answers
114 views

How can MySQL return an empty row matching a given table's schema, given the table name as an input string?

How can a query or procedure return an empty copy of a new record? Ideally suited for objects which are in a transactional allocation process: It is highly preferable to have authoritative defaults ...
user avatar
-1 votes
1 answer
62 views

Terminologies in Oracle-SQL and MySQL | Mutiple Database, Mutiple instances comparsion

In Oracle-SQL: Database = set of physical files on disk Instance = processes, daemons, and memory structures (i.e state of operation) Schema = collection of database objects, including logical ...
user avatar
  • 103
3 votes
1 answer
1k views

I can´t change innodb_buffer_pool_instances

I recently updated my mariadb database to 10.5.5 and I can't set innodb_buffer_pool_instances innodb_log_file_size = 3G innodb_buffer_pool_size = 12G innodb_buffer_pool_instances = 12 But when ...
user avatar
  • 33
-1 votes
1 answer
31 views

Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?

If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it will initialize recovery process. What about SQL Server? Does it behave in the same way?...
user avatar
  • 1,163
0 votes
2 answers
615 views

What are v$database, SID, ServiceName, istance in Oracle 18c?

I have set up Oracle 18c (18.4) on Windows 10 on a company laptop (localhost should be the same as my company's domain name). Once I've created user SYSTEM with password at the installation I tried to ...
user avatar
  • 103
0 votes
0 answers
27 views

How to migrate the SQL Server instance and system databases to a different drive (mapped to a different letter) on the same server? [duplicate]

I'm tasked with moving our SQL Server instance and system databases from the existing drive it's on to a new drive on the same server. I know I can stop the SQL Server service, literally move the ...
user avatar
  • 24.7k
0 votes
1 answer
93 views

What steps do I need to take to move my SQL instance to a different drive on the same server but with the same drive letter?

I need to move my SQL instance to a different drive on the same server but plan to rename the drive to the same drive letter as the original drive the instance was on (after renaming the old drive). ...
user avatar
  • 24.7k
1 vote
2 answers
1k views

SSMS How do I open a new Query Window using Same Connection Instance of current Window

Coming from Oracle I have discovered that SSMS connects slightly different than Oracle's SQL Developer. Oracle you click ONE connection and then all tabs you open then use that Connection. SSMS ...
user avatar
8 votes
1 answer
705 views

Is it possible to determine the default Collation and server version of a database without a full restore?

I work for a company who regularly receives large SQL database backups from clients for support purposes. We support multiple SQL versions and collations, but currently have to manually confirm our ...
user avatar
  • 93
2 votes
1 answer
4k views

Querying a SQL Server's CNAME alias instead of the actual instance name

We don't have a DBA here and our infrastructure analyst is trying his best to give us a test instance on a server using a CNAME alias which neither he nor I have done before. The actual database ...
user avatar
  • 21
2 votes
2 answers
2k views

Availability groups multiple instance, multiple listeners [closed]

In my work environment, I have two database machines: DB01 DB02 Each database machine has three SQL Server instances: MSSQLSERVER FBG Central I've managed to set up availability groups with SQL ...
user avatar
  • 45
4 votes
1 answer
283 views

SQL Server Ignoring Instance name when using port number of different instance

I saw a strange case recently and still clueless on what should be the reasoning behind it. On one of my development server, two SQL server instances are running - one is default and other one is UAT ...
user avatar
2 votes
3 answers
2k views

Multiple instance in one server

Could you please help to explain why one might need multiple instances of SQL Server on the same server? What is a good point to use separate instances? Why wouldn't one use two databases in one ...
user avatar
0 votes
2 answers
308 views

How to find out the service accounts for each of my instances in the current server?

I have the following query that gives me one line for each sql server instance installed in the current server: --list the instances in the current server --marcello miorelli --16-sep-2016 ...
user avatar
1 vote
1 answer
277 views

How do I configure my SQL Server instance to use a different Edition with minimal side effects?

I'm in the process of migrating an old server running Windows 2008 R2 with SQL 2012 Express to a new server running SQL Server 2017 Standard and Windows 2016. I would like to mirror databases between ...
user avatar
  • 111
0 votes
1 answer
2k views

What is meant by "Stand-Alone Instance of SQL Server"

I am cloning a server to perform an in-place upgrade and I will have to change the name of that server - which has a SQL Server with just one instance (default instance) installed on it. I am ...
user avatar
1 vote
1 answer
1k views

How to know which instance is default in Configuration Manager if default port number is changed?

In MS SQL Server Configuration Manager I can see all the instances. I recognize the default one (by saying a default instance I mean the one that listens for 1433) by looking at TCP/IP's IP Addresses ...
user avatar
  • 2,006
2 votes
2 answers
4k views

How to determine which one is my default instance in MS SQL Server?

I have two instances in my server and I want to know which one of them is the default. Can you, please, point out ways I can recognize it. By saying a default instance I mean the one that listens for ...
user avatar
  • 2,006
1 vote
2 answers
5k views

ORA-01503 CREATE CONTROLFILE FAILED... while trying to create a database

i am trying to create a new database along with another database. The server already has a database running. I used DBCA command to create the new db instance. First i set the new SID and home and ...
user avatar
  • 11
3 votes
3 answers
295 views

How to remotely connect SQL Server 2016. Since we have 2012 and 2016 in same server

Issue I am not able to connect to a SQL Server 2016 instance on a remote system/server. My Existing Environment Windows Server 2012 SQL Server 2012 and 2016 installed on same server I tried to ...
user avatar
1 vote
0 answers
505 views

Converting and/or enforcing an Ascii Character Set in Informix database from 819 or ISO Latin 1

Overview: In Informix is it possible to enforce ASCII for a database or instance. Details: I am trying to enforce ASCII in an instance of informix for a while. This is to help have a smooth ...
user avatar
-1 votes
1 answer
70 views

Authorized, all privileged DB user and a DB instance with the same name - does it have a name? [closed]

Is there a term that encompasses an authorized, all-privileged DB user and a DB instance with the same name? Should I call this a DB stack / DB unit / DB packet / something else? Does this "stack" ...
user avatar
0 votes
1 answer
40 views

When do I need more than one Oracle Instance on the same server?

I have one application server separate from an Oracle server (one physical server). I have three instances on one Oracle Database Server (another physical server). I want to have three environments ...
user avatar
  • 532
1 vote
1 answer
26 views

Attempting to setup a new named instance but can't get past the Feature Selection Screen

I have been going through and looking at all of the options listed via google for the better part of the day. No matter how I try to run this, whether initially from the straight GUI interface, using ...
user avatar
2 votes
2 answers
7k views

SQL Server 2016 Multiple Availability Groups and instances

So we are getting ready to make a major architecture shift and I get to be on the hook for it, yay! Currently we have 22 separate availability groups each with their own windows cluster across 44 ...
user avatar
  • 147
1 vote
1 answer
13k views

Mysql 5.7 Could not create Unix socket lock file

I am trying to create multiple instances of MySQL 5.7 in the same Ubuntu 16.10 32-bit box. I have copied the original data dir to the new one. Created separate log folder for the new instance(the logs ...
user avatar
2 votes
2 answers
1k views

Instance Recovery in SQL Server?

When the instance crashes due to unexpected disaster in SQL Server, how does the SQL Server recover the databases? SQL Server goes through which phases to recover the data and which are the steps ...
user avatar
0 votes
1 answer
2k views

Which views can be queried while instance is up but database not mounted in Oracle 11G?

If I understood it correctly, when the instance is started, some views are loaded into memory and we can query against it like v$instance. And it doesn't need db to be mounted. If so, are there any ...
user avatar
  • 135
1 vote
1 answer
6k views

How does SSMS connect to a server's database without the instance name?

I have a question that I am confused about. I am also new to database stuff as well so this question may be basic. For example, at my work, we use SSMS to connect to our server's databases. When ...
user avatar
2 votes
1 answer
930 views

Why does ORACLE cache recovery create uncommited blocks during instance recovery?

The following is an excerpt from an ORACLE book During cache recovery, Oracle replays the transactions from the online redo log files since the last checkpoint. During this roll forward operation,...
user avatar
  • 335
1 vote
1 answer
1k views

Multiple instance on single SQL Server

We have a server running single instance of SQL SERVER in production environment. We are planning to create another Instance of SQL SERVER in same server. My question do we have to buy a new ...
user avatar
0 votes
1 answer
1k views

Can an SQL Server Failover Cluster support a named instance?

If I currently have someName\instanceName on a standalone SQL Server and I want to migrate to a failover cluster, http://itknowledgeexchange.techtarget.com/sql-server/moving-a-standalone-instance-to-a-...
user avatar
5 votes
4 answers
3k views

A few huge instances or many small ones

I recently inherited an environment with around 4000+ databases distributed between 21 instances on 3 huge physical servers. Databases are distributed between different instances based on the name, so ...
user avatar
  • 488
1 vote
1 answer
916 views

TSQL Solution to backup ALL databases on ALL instances of a server?

I'm pretty sure what I'm wanting with my current implementation is impossible, the sys.databases catalog view which is scoped at the service level to be aware of other SQL Server instances (lol). But ...
user avatar
0 votes
2 answers
779 views

SQL Server database stuck in Recovery after Restoring .BAK to same instance

We've had an issue crop up a few times -- maybe we're not using 'best practices' to restore, but appreciate any advice. We run an IIS app with a SQL Server database, and sometimes we run two+ ...
user avatar
1 vote
1 answer
228 views

Default instance name in a cluster

I have a cluster set up with two virtual instance names WIN2K8SQL1\INST1 WIN2K8SQL2\INST2 that was set up by the IaaS company. Now developers are complaining about the naming convention so we ...
user avatar
4 votes
3 answers
398 views

Why does server name need to be specified when accessing local instances?

Even though I have direct access to the physical database machine, I have to specify dbmachine\sql in the connection field, rather than just the instance name. Why is that?
user avatar
0 votes
1 answer
3k views

Instance name is null - SQL Server [closed]

I recently checked this in my SQL server instances: SQL Server 2012 EE: -- get current SQL Server name\instance name SELECT @@SERVERNAME -- get current machine name and instance name SELECT ...
user avatar
  • 1,814
7 votes
2 answers
3k views

How can I find a table in the whole instance?

I am trying to create a report which selects data from a table called costomersHR. I cannot find it as we have hundreds of databases in the instance. How can I search for a table in the whole ...
user avatar
  • 211
4 votes
2 answers
8k views

Unable to change servername after VM Clone

For reasons out of my control I must find a solution to this issue. Simply reinstalling the instance is not an option. The server name that appears as server_id 0 in sys.servers is still showing the ...
user avatar
  • 1,051
5 votes
1 answer
2k views

How to create a server instance of just ComputerName instead of ComputerName\SQLEXPRESS

I'm currently hosting a database on the server MyComputerName using SQL Server Express 2014. I want to move the database to another computer, so I installed SQL Server Express 2014 on it but that ...
user avatar
1 vote
1 answer
259 views

Run PS-Script after job is done on 3 instances - SQL Server

I have backup jobs running on a server with 3 instances. Link to script: https://ola.hallengren.com/sql-server-backup.html The solution I found for the other 2 servers with only once instance was ...
user avatar
0 votes
2 answers
964 views

How to connect to a named SQL Server instance without specifying its name? [closed]

Is there anyway I can connect to a SQL server that has no default instance, using just the server name? I've tried using SQL CMD, but it seems that the named instance name is required to login, ...
user avatar
  • 375