Database administrator

learn more… | top users | synonyms

1
vote
2answers
37 views

Can SQL Server Transactional Replication do this?

We have a production server and a reporting server, with transactional replication in place to move all inserts/updates/deletes from production to reporting. We're using SQL Server 2008 R2. We have ...
0
votes
2answers
26 views

Why do we have negative length for character maximum length for geography and varchar(max) data types?

Why do we have negative length for character maximum length for geography and varchar(max) data types? Character_Maximum_length = - 1
0
votes
2answers
26 views

Get a user's rank from an equation, and then store it in the table

I'm working on a project for my database class, and I have a table called "accounts". It looks like What I want to do is have a stored procedure where it calculates the new ranks for each account. ...
0
votes
0answers
11 views

Proper Partition Alignment SQL Server [migrated]

I'm trying to follow the advice from this technet article about partition alignment. Our San is an EMC, the disks are in a 4 disk raid 10. This is a SQL Server with an I/O intensive application, ...
0
votes
1answer
31 views

What is the risk of doing a rebuild to my indexes in sql server 2012?

What is the risk of doing a rebuild to my indexes in SQL Server 2012? I have to do a REBUILD, but I don't know what are the risks . The server is running and a lot of information is going in and out. ...
0
votes
0answers
17 views

Can't see any services listed in Configuration Manager

I am using SQL Server 2014 and am logged in my desktop as my user account with admin rights. When opening Config Mgr, I do not see any services listed whatsoever. Could this be an issue that ...
0
votes
0answers
46 views

MySQL replication: most important config parameters on slave for performance on master server?

This query is almost the same as this question. But in this case, a configuration to make the master perform faster or just the same. Case We have a Master-Slave setup on a Mysql 5.0.77 - MariaDB ...
0
votes
2answers
39 views

How can delete an orphaned temporary table on Mysql Innodb?

I was issuing an Alter table statement and suddenly the server crashed, Now i can not run any alter table to that table because it shows me the error 1050 and it says that a table named #sql1504d ...
1
vote
2answers
35 views

To what extent can we monitor jobs/suspended queries as DBO

Short Background: I work for company A, at company A we have a DBA that should not be. When we are tasked with items for troubleshooting which require quick turn around, it generally takes quite a ...
0
votes
1answer
42 views

What is contained in the controlfile of oracle database?

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In ...
0
votes
0answers
9 views

Why do I get this CMN_1021[ORA-03135: Connection lost to contact

My Informatica application throws this error not every time but randomly. Not sure of what is the root cause of this ..
0
votes
1answer
43 views

How to directly query other user tables

I am trying to learn Oracle database and I am having difficulties on importing a backup file with impdp command. I googled deeply but couldn't find answers to my problems. What have I done until now ...
0
votes
1answer
45 views

Mysql JOIN with 25million rows

Recently I got stucked with a table where its grown to +25million and I have got a query that's doing a JOIN on it. The query take 2.5hours to execute even though I got Good 96GB RAM and RAID10 with ...
0
votes
0answers
42 views

Problem in ASM starting

iam working on wondows7 and oracle 11.2.0 this is my standalone system as i want to setup the ASM as i haeve createdthree logical Disk and ihave created parameter file for ASM but at the time of ...
0
votes
1answer
103 views

I am upgrading from 11.1.0.7.0 to 11.2.0.3 with R12.1.3 while pre upgrade/catupgrd.sql erroring out ORA-00600

While upgrading from 11.1.0.7.0 to 11.2.0.3 with R12.1.3, during running the pre upgrade script catupgrd.sql, it is erroring out ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi ...
0
votes
0answers
89 views

Report Server Subscription Configuration ISSUE

I Have Created A Subscription in our Development Server With below Steps. 1)Opened Report Configuration Manager and Configure Email Settings. 2) Opened Report Manager and configured a Report Data ...
1
vote
1answer
56 views

Incorrect unit allocation size. error comes when Tuning the Database

Here I am Using the SQL IDERA tool for checking the Index and performance of the Database, then i found below error, can any one tell what is it talking about. Incorrect unit allocation size. ...
0
votes
1answer
69 views

Database simulator [closed]

I've been studing theory of database, but I can't have a concrete image on terms of functionality. I want to be a DBA, I'm studing for it so I want to understand how a database works. Is there any ...
0
votes
0answers
109 views

can Pgpool Work With Multi-master replication in PostgresPlus 9.3 AS?

My query is I have One application server and two database servers(multi-master setup with xDB-replication). Now How can i Connect to two different databases servers having different Ipaddress,Port ...
0
votes
0answers
38 views

Error “Slony-I creation script not avilable ; only joining possible” in SlonyI replication using pgadmin3

I am facing the above issue while Creating a base replication objects like database etc.. As a workaround i have done the changes like editing the options of Binary Paths in Pgadmin Console but no use ...
0
votes
0answers
25 views

SPExecuteSQL;1 keeps executing internally

Having a major issues with this procedure called SP_ExecuteSQL;1. It keeps executing internally in SQL Server 2000 with high utilization of CPU. When I pass its SPID in DBCC inputbuffer it shows as ...
0
votes
0answers
14 views

How can I update the amount on parentid

I'm using MySQL database,This is the first time that i handle this kind of project the Multi-Level Marketing.I am having problem in updating the amount of parentid if he gets paired means he has left ...
1
vote
1answer
72 views

Delete back ups more than 2 weeks in sql server

I am not a DBA, I need to delete the USER_DATABASE backups older than 2 weeks. Is this below stmt work for this scenario? EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASE', @Directory = ...
0
votes
1answer
22 views

Error on mongos server

Firstly,I am new to mongodb. when we executed the below command on mongos server. /usr/bin/mongos --configdb X.X.X.1:20001,X.X.X.2:20002,X.X.X.3:20003 --port 27017 --chunkSize 1 we are getting the ...
0
votes
1answer
125 views

Error when trying to add a shard set in Mongo db

I'm trying to add a shard set in mongos I got this error and . Kindly help. mongos>db.runCommand( { addshard : " firstset/ip_1:port_1,ip_2:port_2,ip_3:port_3" } ); { "ok" : 0, ...
0
votes
1answer
36 views

Can any one Explain me What is the Use of Cascading Replication in Postgresql?

What are the advantages of cascading replication in PostgreSQL. I have done Testing On this With three nodes. M1---->S1----->S2 What is the Use if My master(M1) goes Down(failover). Where the ...
2
votes
2answers
250 views

Multiple Instance with different service packs in SQL Server

I would like to install a Default instance with SQL Server 2008 R2 RTM and I want to install another named instance with SQL Server 2008 R2 SP2. Is this possible?
0
votes
1answer
69 views

Exadata RMAN vs. Non-Exadata RMAN - any differences?

Can you please let me know the differences, if any, in the architecture of the non-Exadata RMAN vs. that of the Exadata-RMAN from an SBT plugin perspective? Have you observed from your vast ...
1
vote
1answer
174 views

Copy Database from Production to Development

I need to copy database from production to development instance in SQL Server 2012 as I don't want to mess up the production server database. Can someone suggest how I can do this ?
0
votes
1answer
51 views

Index file - size changed

I realised today that my index file(which is about 250GB) is smaller than yesterday for about 7GB. Everything, I done in the meantime, was index rebuild. Is it possible that index rebuild is the ...
0
votes
1answer
80 views

Maintenance plans

I am an accidental dba..I did post a message a while ago about Index fragmentation and some of you suggested maintenance plan and others suggested custom Olla's scripts. I have downloaded his scripts ...
0
votes
3answers
193 views

index rebuild/reorganize frequency

I am a dba by accident. I am doing index rebuild/reorganize. I would love to use some scripts once I become comfortable doing these tasks. I did go through some of the forum pages regarding this ...
0
votes
0answers
38 views

Pulling all data modified in a month [duplicate]

i am required to WRITE A SCRIPT that pulls all the data that has been modified in last 30 days from a database. What approach do we need to follow.
0
votes
1answer
50 views

How to setup large database access/cache on LAMP environment? [closed]

My application is getting very slow I guess because of the ever growing database (30+ tables some with 50,000+ rows). Using CodeIgniter's model tier to call MySQL database, I optimized queries & ...
0
votes
0answers
12 views

SQL server - copying tables, constraints and indexes from one database server to another server [duplicate]

An accidental DBA, We have sql server 2012 on both of our payroll production server and development server. We have to copy few tables and indexes and constraints from the production database to the ...
0
votes
0answers
61 views

connecting Pervasive PSQL and MYSQL

I have Peachtree/Sage 50 on the server and trying to sync/integrate with MySQL, I already created a ODBC datasource but how can import all tables in sage to MySQL. What im trying to accomplish is to ...
0
votes
1answer
33 views

Who should own the staging database right

At my company we are re-assessing which developers will take on the deployment for xyz ticket. At the moment when a developer is done with his ticket, a deployment ticket is created and another ...
1
vote
0answers
200 views

PLSQL Compilation error for other users/

I created a plsql procedure that queries the database and dumps the result onto a CSV file. I am an application developer and I have dba rights to my oracle database. I'm able to compile and run the ...
0
votes
1answer
40 views

How to do Mysql migration from 5.0 (320bit windows) to 5.6 (64 bit windows)?

I want migrate My Mysql 5.0 windows 32 bit to Mysql 5.6 Windows 64 bit? Please suggest me the best way to do migration, i have around 10gb of data present in Mysql 5.0.
0
votes
1answer
2k views

How to grant permissions for User defined type in Oracle

This is probably easy but i can't seem to figure it out. I created my user-defined type as CO_ADMIN. However, the application using the type runs using GS_USER database account. I have granted ...
0
votes
1answer
84 views

Can anyone recommend a beginner DBA course in London [closed]

My organisation is in need of a SQL Server DBA and as the companies only "SQL Guy" my boss has suggested me to take SQL Server DBA course. My general T-SQL knowledge is fairly good, I can write ...
0
votes
0answers
39 views

Restore data from MYSQL Bin log

I am trying to restore some data from mysql bin log file. But when it encounter some special characters, query gets break and I am not able to continue after that. Is there any way to handle special ...
0
votes
0answers
39 views

Sql Server Agent Job

In my Local SQL Server 2008 I created a scheduled job (like daily email will send to particular user from the database based on condition). Now I decided to host my schedules in hosting server so can ...
0
votes
0answers
74 views

How to increase the size of the tablespace in Postgresql?

I have created a tablespace in PostgreSQL with name abc and location of the tablespace is /opt/PostgreSQL/9.2/data/dbspace,Now i want to increase the size of the tablespace is it possible in ...
1
vote
0answers
57 views

How many Maximum Number of database can be created in single instance of PostgreSQL? [closed]

How many Maximum Number of database can be created in single instance of PostgreSQL 9.x?
0
votes
1answer
39 views

Can PostgreSQL results include the query?

I run the following command to run 2 queries in a sql file. Could be 1, could be 50 queries. Depends on the deployment. psql -U <username> -h <servername> -d <databasename> -f ...
2
votes
3answers
186 views

Transaction log back up

Another accidental DBA question. We have a DB instance that host 10 databases. This DB server doesn't have any maintenance plan set up. I want to set up a decent maintenance plan that will do a full ...
0
votes
2answers
4k views

Reclaiming data file free space after deleting a large amount of data

I am an accidental DBA. We have a sql cluster that hosts 10 databases. Suddenly the size of one of the database increased drastically from 100GB to 250GB. When we checked the datafile, the size had ...
0
votes
0answers
30 views

Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?

I have small doubt regarding Mysql Active-Active Replication. Can it Possible to do Mysql Master-Master (Active-Active) replication in Mysql between Redhat Linux and Ubuntu? Thanks & regards, ...
0
votes
0answers
497 views

A issue on DB link between Postgres and Oracle?

I am trying to create a DB link between Oracle and PostgreSQL using OCI. CREATE DATABASE LINK oraedb CONNECT TO hr IDENTIFIED BY 'hr' USING oci '//127.0.0.1/xe'; CREATE DATABASE LINK When I ...