Questions tagged [database-administration]
The database-administration tag has no usage guidance.
296
questions
10
votes
3
answers
1k
views
Importance of location of installation of Microsoft SQL Server
I have a server with cheap slow disk and an expensive fast disk.
I want to use the expensive disk for all the things where it's important that it's fast, such as my databases.
To save money, I want ...
1
vote
2
answers
6k
views
How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it
I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close 90%...
-4
votes
1
answer
425
views
mysql remote server connection fails [closed]
I'm working on this for 4 days and I know it is all over google, but I did all the required stuff but still no connection.
I created to 2 vagrant boxes, one for web server and one for mysql.
web: ...
0
votes
2
answers
7k
views
User with grant permissions cannot grant permissions for new user with and new database
I am using: mysql 5.5.43-0 on ubuntu 14.04.1
I try to create a new admin-user (admin) who is allowed to do the following things:
a creating new users (dbuser1) with password - (permission "create ...
4
votes
2
answers
2k
views
PostgreSQL limiting connections to fewer than max_connections?
I have a PostgreSQL 9.4 server that seems to be limiting connections to fewer than what I have defined in max_connections.
I have max_connections set to 300.
SHOW max_connections;
max_connections
--...
4
votes
1
answer
341
views
Reclaiming free space in filegroup with single chronological partition
-moved here from SO (no coments there)
Question:
what is a proper way of reclaiming space in big (hundreds of GBs) filegroup with single partition of table that is chronologically ordered and has no ...
4
votes
2
answers
424
views
How to implement table security without SUPER privilege?
A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case ...
0
votes
1
answer
2k
views
Setting up Multi server environment in Sql Server 2012 - Enlist Failed Error
I am trying to Configure the Master target server / Multi server environment in Sql Server 2012.
I changed :
MSXENCryptChannnelOptions # Changed from 2 to 0
AllowDownloadedJobsToMatchProxyName # ...
-3
votes
1
answer
60
views
How should my company bring its product, a line-of-business MVC application, into the cloud? [closed]
I am a recently-hired junior software engineer at a small company that develops and sells a normal client/server MVC application to small and mid-level enterprise clients in a particular line of ...
0
votes
1
answer
729
views
I set up a web application server, and a separate server for postgres on the same network. How should I secure the connection?
I'm trying to determine the best, modern practice for using your own separate database server for a web-app. I have an app server, appserver1, (running php, nginx, etc, not that that matters much), ...
1
vote
1
answer
9k
views
Importing Data Dump Using pgAdmin
I looked around and found the following code on how to import a data dump using pgadmin:
CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$
tables RECORD;
gmdeclare
statement TEXT;...
4
votes
3
answers
4k
views
How can I drop a MySQL user whose username contains unprintable characters?
I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user?
mysql> select user,host from mysql.user where user like 'wiki%';
+-----...
1
vote
0
answers
65
views
Axis DMsuite RESTful API
I'm looking at Axis DMsuite for masking Oracle databases. I was told by their staff that they exposed some simple REST endpoints for triggering masking jobs, but I have done a fair bit of searching ...
1
vote
0
answers
265
views
MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber
This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
3
votes
2
answers
7k
views
Most reliable MariaDB to Postgres dump method
I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql.
Most documentation indicates that the following format should ...
0
votes
1
answer
3k
views
OsTicket + IIS + mySQL + Extremely slow queries
Background: I am a .net developer, limited php coding knowledge
Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket ...
1
vote
1
answer
825
views
What maintenance tasks should I run on my MS-SQL 2008/2012 servers?
The servers are using database mirroring for high-availability running SQL server standard on newer hardware.
The existing plans were setup by a DBA many years ago and are using the built in ...
-1
votes
1
answer
51
views
Moving MYSQL database Cache issue?
I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess.
...
0
votes
2
answers
5k
views
Microsoft SQL Server Standard High Availability without Shared Storage
I'm a software dev with little experience managing SQL so please bear with me!
We are developing a piece of software that needs to be highly available, with a significant degree of resilience.
This ...
4
votes
2
answers
27k
views
MongoDB Auth, can be authenticated in the shell but not via the command line
I have an application that connects to a MongoDB database called discussions. I've created a user
Mongo shell:
> use discussions
switched to db discussions
> db.auth("discussions","XXXXXXXXX")...
1
vote
1
answer
538
views
MSSQL: Roll back DB from backed up .MDF/.LDF
I've mistakenly deleted a table in Microsoft Server Management Studio, and the restore function was not properly configured.
I have older .mdf and .ldf files of the particular db with the deleted ...
1
vote
1
answer
1k
views
Very strange disk-usage for replica in Mongodb
tl;dr: the new 2.6 replica eats up a lot more disk space than the 2.4 members.
We're heavy users of MongoDB's GridFS. We're currently on 2.4, and are intending to upgrade to 2.6 by simply adding a ...
0
votes
1
answer
766
views
Setting Up Replication/master slave configuration to mariaDB
I'm starting my project using mariaDB
I want to setup master slave configurations on windows 7 64Bit. I don't know how to setup this kind of configuration.
I've searched on google, visited websites ...
2
votes
1
answer
1k
views
Postgresql: missing data after crash
I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet).
Server: centos, Postgresql: 9.2.8
It looks like all my postgresql databases were reverted to the state ...
6
votes
1
answer
131
views
Copy SQL Server Databases
I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB.
I've seen and even used some of the various data ...
-1
votes
2
answers
6k
views
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES) [closed]
root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
2
votes
2
answers
11k
views
Scheduled copy of production database into test database
My question is similar to this one.
I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and copy/...
1
vote
0
answers
1k
views
MongoDB Performance Troubleshooting
I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
1
vote
1
answer
216
views
Error in cross server sqlcmd execution due to firewall issue
I have an application server with an IP of 10.107.0.100 and one database server on which SQL Server 2012 is installed, with an IP of 10.107.0.101.
Remote connections are made to this server, and the ...
4
votes
1
answer
1k
views
Regarding High Availability for MSSQL Server
Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which ...
1
vote
1
answer
2k
views
HeidiSQL, attach/register database in MSSQL server
How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
2
votes
1
answer
53
views
Confused about horizontal scalling
Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, ...
-1
votes
1
answer
47
views
Database management [closed]
First of all please forgive me if this question is off the topic. I have a developed social networking site where users can upload photos and update status. I thought of hosting in AWS EC2, but to get ...
0
votes
2
answers
6k
views
SQL server databases are stucked in restoring state
I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that ...
0
votes
1
answer
429
views
Which db managment software can copy from one sqlite3 table to another for fields which are common in both?
We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has ...
0
votes
0
answers
190
views
MySQL response times spiking at regular intervals
I recently set up a windows Hyper-V VPS with a bitnami django stack. I am monitering the website with newrelic. I noticed that my MySQL database response times spike about every 30 min. My first ...
0
votes
1
answer
621
views
How can I change the Postgres data_directory folder location?
I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
0
votes
1
answer
679
views
MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)
When ever I type in :
GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********';
It gives me an error of :
ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
0
votes
1
answer
71
views
Confusing MySql Error
I am trying to install an application on CentOS, and see this error in my apache log.
If any can help me understand what exactly is the case, I can try to work on a solution for the error.
This is ...
5
votes
3
answers
8k
views
How to disable 1 version of PostgreSQL server without uninstalling it
I have installed PostgreSQL 9.1 and 9.2 on my Ubuntu machine. The postgresql service starts both versions:
$ sudo service postgresql start
$ * Starting PostgreSQL 9.1 database server [ OK ]
$ * ...
1
vote
2
answers
2k
views
InnoDB Buffer pool hit rate missing from engine status output
I want to check the buffer pool hit rate for InnoDB on MySQL but when I query the database the hit rate seems to be gone from the results:
Using query: SHOW ENGINE INNODB STATUS\G
-------------------...
2
votes
0
answers
292
views
SQL Azure Automated Backups doesn't work
I configured automated export of my SQL azure db, but backups are not created.
Also, I'am resieved this mail.
Automated SQL Export failed for [servername]:[dbname] at 25.09.2013
23:06:45. The ...
0
votes
1
answer
174
views
Setting innodb_buffer_pool_size in for Mysql
We have a dedicated DB box with with 8 GB of RAM and running Redhat linux 64 bit OS. Our MySQL Data + Index size almost 7.8 GB. About setting innodb_buffer_pool_size, I have read 2 suggestions
Set it ...
0
votes
1
answer
1k
views
CouchDB administrator password reset
I have an install of couchDB, and somewhere along the line, a malformed request via CURL has my admin accound with a password that I don't know. Short of setting up another Couch server, then ...
13
votes
2
answers
14k
views
How to undo assigning ownership of db_datareader/db_datawriter schema?
i meant to assign an SQL Server login to the
db_datareader
db_datawriter
database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them instead:
...
0
votes
1
answer
2k
views
Why won't Postgres start after stopping it?
Postgres was running just fine (I have created a database using template0). Then, I used:
$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop --mode=smart
to stop Postgres and it stopped ...
1
vote
0
answers
29
views
My transactional overnight batch has spiked in duration
I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
-1
votes
1
answer
47
views
InnoDB Failure of some kind [closed]
I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked.
InnoDB is listed under SHOW ENGINES;
Any idea ...
0
votes
1
answer
8k
views
Command to list event monitors in DB2
I see the following commands:
drop event monitor
set event monitor
create event monitor
But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
1
vote
1
answer
3k
views
Is it possible to increase the max limit of 10 pc's to any number of times without making the user a domain admin?
Normally a domain user has a maximum limit for 10 computers to join to a domain. But what i want to know is, is it possible (by joining a account to a group) to do this any number of times without ...