Database administrator

learn more… | top users | synonyms

7
votes
5answers
2k views

Are there any professional fulltime PostgreSQL DBA's?

For my job I work on a JavaEE application with PostgreSQL as the database. Although we have a sysadmin for our productions servers, who also manages our database servers, we have no full-time DBA ...
5
votes
3answers
2k views

Do roles have an owner in oracle?

Suppose that I have logged in to oracle database using user X, then user X creates some roles using create role command. I want to know that is user X the owner of the roles? Can I select all roles ...
4
votes
1answer
474 views

SQL Server Restore from one database to another

One of our devs backed up a dev database, and then restored it in production. It's a new database for a new app that was deployed last night intentionally to prod. Now in the backupset table ...
4
votes
1answer
216 views

The future of DBAs with ORM [closed]

I am an aspiring DBA (I'd say in ~3 years I would be ready to apply for a job) and I currently am a programmer. I relayed my future goals to a friend of mine who is part of an Agile SCRUM team in a ...
4
votes
1answer
218 views

Managing Access for DBA and IT Support

We are currently in the process of moving our development, test and live databases on to separate servers and instances and I am looking at how best to manage access for DBA tasks and also IT Support ...
2
votes
3answers
187 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 ...
2
votes
2answers
117 views

What is the recommended method to move databases?

I want to know the recommended method to move a database and data from dev to pre-prod to production in SQL Server. The databases are originally created in MS Access so some upsizing to SQL Server ...
2
votes
2answers
289 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?
2
votes
1answer
2k views

Migrate / Copy Huge data from Oracle to SQL Server

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this ...
2
votes
1answer
136 views

Junior DBA hopes for advice [closed]

This is the 7th month of my DBA career, and I just graduated as a master, no experience before. My daily work for now is pretty much about backup/restoring databases in different environments ...
2
votes
0answers
26 views

SQL Agent Jobs Automatically Disabled After Modifying Maintenance Plan

Hoping someone can shed some light. I modified a maintenance plan yesterday, to find out this morning (by using the last modified date from sysjobs) that all jobs related to the maintenance plan are ...
2
votes
0answers
97 views

SQL Server Online Training [closed]

I recently took an intro class for MySQL from www.oreillyschool.com and it was very helpful. The next class they offer is administering MySQL but I currently work with SQL Server. The first class was ...
1
vote
2answers
34 views

Restore a newer filegroup backup

So this is my set up. In our data warehouse we have mostly tables that are filled with data from a ETL-process. We do not take backup of these tables since we have an option to do a full reset using ...
1
vote
2answers
35 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
1
vote
1answer
189 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 ?
1
vote
1answer
1k views

Oracle delete technique for table's segment size (data compactness)

I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before: ...
1
vote
2answers
42 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 ...
1
vote
1answer
77 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 = ...
1
vote
2answers
2k views

Free up disk space on sql server

Assuming I have a sql database server with disk space as follows: D Drive: 10GB (For the MDF file) E Drive: 10GB (For the LDF file) And I have only one database on the server with the following ...
1
vote
2answers
36 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 ...
1
vote
1answer
925 views

InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”

MySQL 5.5.24 . We have InnoDB tables that grew almost by double (from 50GB to 100GB - file-per-table enabled) in a few weeks due to a project we are working on. The tables were freshly dumped and ...
1
vote
1answer
64 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. ...
1
vote
0answers
228 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 ...
1
vote
0answers
59 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?
1
vote
1answer
220 views

How to become a sql dba [closed]

I'm working as a software consultant with about 3+ years of experience in Microsoft .NET with SQL Server 2008 and 2012. I'm having interest in SQL Server and possess basic knowledge of SQL that i can ...
1
vote
1answer
120 views

Difference between sql agent account logged in as NTLM and UPN?

Can someone please tell the difference between a sql agent account logged in as NTLM and UPN? What is the difference if the sql agent account is logged in as: domain\username and username@domain.com? ...
1
vote
1answer
270 views

cons of linked server providers not running in “allow in process” [closed]

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been ...
1
vote
0answers
56 views

Integration Service cannot be upgraded/removed

I have Sql Server 2005 Integration Services installed in our server whose version is 5292. It needs to be upgraded to version 5324. After running the patch the summary report says it is upgraded ...
1
vote
1answer
240 views

I need advice on these queries

could you help me optimize these queries? here are queries, please note that you see something like OR 1=1 OR those are values I pass via php and may change. query#1: SELECT posts.status, ...
0
votes
3answers
208 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
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
2answers
24 views

is it a good practice to ip block dev/test app servers from production database server? [closed]

I would like to do this as somewhat of a last line of defense as we will be replicating production to test regularly. Is this good practice?
0
votes
3answers
132 views

How to manage constants within an Oracle Database

This question touches on a few different parts of Oracle that I'm not particularly familiar with so bear with me: I am trying to redesign some of the procedures and functions within the database I ...
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 ...
0
votes
2answers
12k views

How to Create users in sql server for accessing only one database using Management Studio [closed]

How to Create users in sql server 2008 R2 for accessing only one database using Management Studio. regards, salman
0
votes
1answer
72 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 ...
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
2answers
197 views

Restoring Oracle DB using RMAN

I am a application developer doing DBA work. I have to restore an oracle database on our test server. The databases are backed up using RMAN and the last db restore that was done on this server was in ...
0
votes
1answer
32 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
1answer
116 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
1answer
83 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
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
138 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
41 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
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
1answer
196 views

Select Into Regexp_replace doesn't write changes into newly generated table

I have been using this query in postgres 9.1 in order to remove '' from existing data. Below is a sample of the data before running regexp_replace. 6'' 6'' 6'' 20'' 12'' 18'' 20'' 8'' 10'' '' '' ...
0
votes
1answer
96 views

Timestamp with time zone

Please can you explain the meaning of this sentence! Two TIMESTAMP WITH TIME ZONE values are considered identical if they represent the same instance in UTC, regardless of the TIME ZONE offsets ...
0
votes
2answers
8k views

SQL Server Management Studio - connection with SQL Server database engine

This question is in regards with SQL server 2005 and 2012. I have a database server with two instances of SQL Server. Through SQL server management studio I was able to connect to both instances by ...
0
votes
1answer
145 views

Install and Configure Oracle 11g using c# program [closed]

I need to create a windows application program using c# which will allow me to install oracle client 11g and also configure ODBC automatically with just one click, as my customers have limitations in ...