Questions tagged [database-administration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Niels Brinch's user avatar
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%...
gaganHR's user avatar
  • 121
-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: ...
Tzook Bar Noy's user avatar
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 ...
Stephan's user avatar
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 --...
Legion's user avatar
  • 233
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 ...
Jan's user avatar
  • 151
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 ...
Alex R's user avatar
  • 1,083
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 # ...
user3325655's user avatar
-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 ...
presidentsandals's user avatar
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), ...
Kzqai's user avatar
  • 1,288
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;...
Max Power's user avatar
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%'; +-----...
Scott Dudley's user avatar
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 ...
Ryan S's user avatar
  • 46
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 ...
acatala's user avatar
  • 11
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 ...
tony_perkis666's user avatar
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 ...
Louis van Tonder's user avatar
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 ...
Developr's user avatar
  • 912
-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. ...
Leoric80's user avatar
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 ...
RAGNO's user avatar
  • 111
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")...
monksy's user avatar
  • 357
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 ...
zillaofthegods's user avatar
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 ...
vpetersson's user avatar
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 ...
Ashish Ratan's user avatar
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 ...
EoghanM's user avatar
  • 560
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 ...
Black Dynamite's user avatar
-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)
sivashanmugam's user avatar
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/...
Jonathan's user avatar
  • 121
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 ...
nocode's user avatar
  • 168
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 ...
darshan doshi's user avatar
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 ...
darshan doshi's user avatar
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
ZEE's user avatar
  • 336
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, ...
Benjamin Smith Max's user avatar
-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 ...
Robin's user avatar
  • 109
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 ...
Pooya Yazdani's user avatar
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 ...
user938363's user avatar
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 ...
Max Ferguson's user avatar
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 ...
AmShegar's user avatar
  • 259
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 ...
user2833135's user avatar
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 ...
Vijit Jain's user avatar
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 ] $ * ...
Bartłomiej Skwira's user avatar
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 -------------------...
Bart's user avatar
  • 113
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 ...
IGusev's user avatar
  • 21
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 ...
nitin's user avatar
  • 2,599
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 ...
spuy767's user avatar
  • 203
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: ...
Ian Boyd's user avatar
  • 5,373
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 ...
orokusaki's user avatar
  • 2,873
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 ...
Cheetah's user avatar
  • 241
-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 ...
Tiffany Walker's user avatar
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 ...
Jason Axelson's user avatar
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 ...
Anonymous's user avatar