Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
0
votes
0 answers

Finding pending cassandra pending compactions information

I am trying to understand the pending compaction statistics that are displayed by cassandra nodetool that can be seen two ways. I am on cassandra 3.11.3. Why would the compaction statistics be different in nodetool tpstats and nodetool…
randominstanceOfLivingThing
  • 111
  • 3
0
votes
0 answers

How to expose multiple databases in local network for other applications to connect with them

I am following up this question here, in which I made the incorrect assumption of being able to access a database using HTTP. Because I seem to lack conceptual knowledge, I would like to ask a more general question first: What's a good way to expose…
linus
  • 101
  • 2
0
votes
1 answer

mysql, relocating individual databases vs entire data directory

I need to relocate mysql customer databases to another disk, for the purposes of: 1. Separation of user data from system files 2. Ease of backing up system and user data separately 3. Ease of upgrading the system The following articles were…
Gary Aitken
  • 123
  • 6
0
votes
1 answer

How to DENY access for a particular database for login "sa" and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create another login called "AuditLogin" which should be able…
Jey Geethan
  • 775
  • 1
  • 6
  • 11
0
votes
1 answer

Postgres Role required to grant CONNECT on a specific database

I am trying to GRANT CONNECT on a DATABASE to a user as a schema owner in that database. The schema owner is not a superuser. Do I need to be the owner of a database to execute GRANT CONNECT ON DATABASE DBXXX TO USER_YYY; ?? What role should a user…
DerpDerp
  • 103
  • 4
0
votes
1 answer

Is there split brain possibility

If there are 10 cameras recognizing number plates, and sending the data to the server with a backup server synchronized, is there a possibility to have split-brain problems when some things go wrong? Every piece of data has a timestamp, so if…
Lenni
  • 9
  • 1
0
votes
1 answer

SQL SERVER Express Connection String for User Instances same on SQL Server Standard

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access: Data Source=.\SQLExpress; AttachDbFileName=|DataDirectory|\dash.mdf; Integrated…
Justin
  • 189
  • 1
  • 8
0
votes
1 answer

Everyday the DBs are in Recovery pending state

I have an Azure Virtual Machine hosting a SQL Server 2016 named instance. On this instance I have several DBs. Now, everyday we shutdown the virtual machine at 11.59PM and restart it at 8.00AM. The problem is that everyday I find some of the DBs in…
gvdm
  • 101
  • 3
0
votes
4 answers

Is there any major performance issue if you switch default-storage-engine setting from InnoDB to MyISAM?

Recently we upgraded version of MySQL on the database server, Almost all of our tables are in MyISAM but in my.ini we have set --default-storage-engine=InnoDB But now we want to change this setting to MyISAM because previously we were using MyISAM…
Vishal
  • 215
  • 2
  • 9
0
votes
2 answers

How do I configure SQL Server to name database backup files by date or other pattern?

When SQL Server 2005/2008 database backup jobs are run from Maintenance Plans, can they be configured to include some sequence number (or other indicator) in the filename, so that previous files with the sane name aren't overwritten? (Note I'd like…
Howiecamp
  • 495
  • 2
  • 9
  • 17
0
votes
1 answer

How to migrate postgresql data?

I have a on-premise postgresql database and have to migrate its data to aws aurora postgresql. However the back up is taken using pg_start_backup. Can I use pg_restore to restore it? Has anyone encountered any issues, What should I be concerned…
Swat
  • 465
  • 5
  • 7
-1
votes
1 answer

MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used

MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used Any tuning need to be set on my.cnf file. Every week I am manually restarting server
Anand Bala
  • 1
  • 1
-1
votes
1 answer

How do you stop a hacker from changing passwords in your DB directly, if they're already in a position to steal the DB?

I've been researching the methods of securely storing user passwords in a database (by only storing the hashed password, with a strong algorithm, along with a salt, and deriving the key after so many iterations, like pbkdf2). This is great for if…
papiro
  • 159
  • 1
  • 8
-1
votes
1 answer

Active Directory CSV QUERIES NOT ADMIN

My situation: I work at a help desk and have access to the server active directory is on. I do not have edit privileges. I am in control of inventory and need to have a way to get employee information more efficiently then navigating through the…
user370480
  • 13
  • 2
-1
votes
2 answers

How to move PostgreSQL data directory?

My PostgreSQL installation by default uses /var/lib/pgsql directory to store data, backups and configuration files. As my disk space is running out, I have installed new hardware and mounted it in the /data directory. Having this done, I would like…
Petr Mánek
  • 103
  • 1
  • 4
1 2 3
…
19
20