Stack Overflow
Stack Overflow

Questions tagged [database-administration]

The aspects of database usage not directly related to the insertion and extraction of information, such as security, configuration and performance tuning. These questions are OFF-TOPIC FOR STACK OVERFLOW; ask them on dba.stackexchange.com instead.

Note: There is a separate Database Administrators site dealing with database administration. If the programming aspect of your question is only minor, consider posting there.

Database administration is the umbrella term for a wide range of database-related activities, ranging from installation and configuration, to stability monitoring, performance tuning and security auditing.

2087 questions
15
votes
2 answers

What is an Extended Stored Procedure in MS SQL Server?

What is an extended stored procedure in SQL Server?
thevan
  • 10,052
  • 53
  • 137
  • 202
15
votes
3 answers

How do I add an admin user to Mongo in 2.6?

I upgraded from 2.4 to 2.6 and authentication broke. This tutorial seems pretty straightforward but I keep getting locked out of my own database. My situation is pretty simple, I have a single Mongo server and need one user/pwd combination to…
Tony
  • 18,776
  • 31
  • 129
  • 193
15
votes
6 answers

How to monitor MySQL space?

I downloaded a VM image of a web application that uses MySQL. How can I monitor its space consumption and know when additional space must be added?
lamcro
  • 6,069
  • 18
  • 57
  • 70
15
votes
5 answers

set new value for "ft_min_word_len " FULLTEXT in mysql

I changed to "ft_min_word_len" = 4 by my-innodb-heavy-4G.ini located in my system path "C:\Program Files\MySQL\MySQL Server 5.1" , but when i run SHOW VARIABLES LIKE 'ft_min_word_len' I got still result value= 4. I did not find this variable in…
Rahul Rawat
  • 999
  • 2
  • 17
  • 40
14
votes
4 answers

ORA-01219: database not open: queries allowed on fixed tables/views only

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- ORA-01219: database not open: queries allowed on fixed tables/views only) I looked for sgadef.dbf file and it was missing in home…
Devoloper250
  • 753
  • 2
  • 8
  • 12
14
votes
2 answers

SQL Database Best Practices - Use of Archive tables?

I'm not a trained DBA, but perform some SQL tasks and have this question: In SQL databases I've noticed the use archive tables that mimic another table with the exact same fields and which are used to accept rows from the original table when that…
matrix4use
  • 611
  • 1
  • 6
  • 20
13
votes
4 answers

Drop SQL Server database from powershell

I have a SQL Server instance on my local computer called .\SC. I want to drop a database from that instance using a PowerShell script. I need to login with the sa user for my database. This is the code I have so far, but it doesn't…
user952342
  • 2,602
  • 7
  • 34
  • 54
12
votes
2 answers

Disable users of a database not Logins in SQL server 2008

To disable users of a Database in SQL Server 2008, I gave the command: Use Database Go Revoke Connect from username; It works for the users with SQL Server Authentication such as abcdef. But not for the user with Windows Authentication such as…
Anandita Sharma
  • 405
  • 1
  • 3
  • 9
12
votes
2 answers

VACUUM cannot be executed from a function or multi-command string

I have written a script, using PL/pgSQL, that I run in pgAdmin III. The script deletes existing DB contents and then adds a bunch of "sample" data for the desired testing scenario (usually various types of load tests). Once the data is loaded, I…
Robert N
  • 1,156
  • 2
  • 14
  • 32
11
votes
2 answers

Deadlock on same table with X and U lock

I have a stored procedure with the following two transactions under Begin and Commit tran. UPDATE mytable SET UserID = @ToUserID WHERE UserID = @UserID DELETE FROM mytable WHERE UserID = @UserID On running that Store Procedure with…
Raghav
  • 8,772
  • 6
  • 82
  • 106
11
votes
6 answers

Connecting using MongoDB Compass

I'm trying to see the contents of a collection using MongoDB Compass. I have username/password authentication set up. I can log in successfully but can't see any documents in the collection. Instead, I see the error: An error occurred while loading…
wicccked
  • 352
  • 1
  • 4
  • 15
11
votes
5 answers

No start database manager command was issued. SQLSTATE=57019

I am new to DB2 and I have installed DB2 9.7. I created an instance which is shown below [sathish@oc3855733574 ~]$ db2ilist sathish Settings of /etc/services is shown below DB2_sathish 60000/tcp DB2_sathish_1 60001/tcp DB2_sathish_2 …
Sathish Kumar
  • 2,150
  • 10
  • 29
  • 51
10
votes
2 answers

How to correctly make a public synonym

This is a pretty silly one, but I need help. I have a table owned by mydbowner. It is named mydbowner.mytable. I tried to make a public synonym by issuing the command: CREATE OR REPLACE PUBLIC SYNONYM mytable FOR mydbowner.mytable; When I do this,…
Joe
  • 7,922
  • 18
  • 54
  • 83
10
votes
5 answers

PostgreSQL find locks including the table name

I'm trying to take a look at locks that are happening on specific tables in my PostgreSQL database. I see there's a table called pg_locks select * from pg_locks; Which seems to give me a bunch of columns but is it possible to find the relation…
TheLovelySausage
  • 3,838
  • 15
  • 56
  • 106
10
votes
4 answers

How to install mysqlbackup?

I would like to use mysqlbackup to do incremental backups. However I can't figure out how to install it. I have mysql-server installed. The documentation (http://dev.mysql.com/doc/mysql-enterprise-backup/3.7/en/mysqlbackup.incremental.html) seems to…
pacman
  • 2,050
  • 4
  • 16
  • 17
1 2
3
…
99 100