Questions tagged [database-administration]
296 questions
1
vote
1 answer
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;
begin
FOR tables IN
SELECT (table_schema…
Max Power
- 21
- 1
- 4
1
vote
0 answers
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 and found no documentation. Is anyone…
Ryan S
- 46
- 6
1
vote
0 answers
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 later, as if nothing happened, leaving a 3+ hour…
acatala
- 11
- 2
1
vote
1 answer
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 maintenance tools available in the UI.
Daily:
Full Backup…
Developr
- 872
- 3
- 9
- 19
1
vote
1 answer
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 table in it. How would I properly restore the older…
zillaofthegods
- 113
- 5
1
vote
1 answer
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 new replica members and gradually deprecate the 2.4…
vpetersson
- 861
- 1
- 11
- 22
1
vote
0 answers
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 and is a M1.medium (1 cpu, 3.7 GB RAM).
We have…
nocode
- 168
- 10
1
vote
1 answer
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 firewall is ON and the server is running Windows…
darshan doshi
- 51
- 3
1
vote
1 answer
HeidiSQL, attach/register database in MSSQL server
How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
ZEE
- 326
- 3
- 14
1
vote
2 answers
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
----------------------
BUFFER POOL AND…
Bart
- 113
- 6
1
vote
3 answers
Normal database changes into a snapshot database when server is rebooted
This subject is a little bit outside of my experience, but we are trying to
upgrade our server. We have a new machine, but are using the same versions
of the servers on it (MS Server 2003, and SQL Server 2005).
On our first attempt, we had…
Marshall
- 133
- 8
1
vote
0 answers
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 it's spiked and finishes at just after 4.15am…
Cheetah
- 241
- 3
- 8
1
vote
1 answer
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 making the user a domain admin?
Anonymous
- 11
- 2
1
vote
1 answer
dropping a MySQL table in a method complying to the Department of Defense Data Clearing and Sanitizing Standard
I need to delete a set of MySQL tables for a client in a manner that's compliant with the Department of Defense Data Clearing and Sanitizing Standard. I've a list of acceptable tools including wipe, but I'm not clear on how I might be able to drop a…
ceejayoz
- 32,910
- 7
- 82
- 106
1
vote
1 answer
Installing MS SQL Server 2008 R2 Utilizing Data Array
Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right.
I have a new server that has Windows Server 2008 R2 loaded onto a RAID 1 configuration. I need to install SQL Server…
burmat
- 195
- 1
- 7