The discipline of Operational and Architectural Management of Database Systems.
4
votes
3answers
117 views
Can anyone describe the step by step process of recovery , backup and restore in sql server
Can anyone describe the step by step process of recovery via backup and restore in SQL Server 2008.
If possible please include some examples.
0
votes
2answers
234 views
Is there data visualisation tool for postgresql which is capable of displaying inter schema relations as well?
Operating system used is linux. I have tried Navicat and SQL Power Architect. They did display relations between tables in the same schema. I have some foreign key constraints which reference tables ...
0
votes
1answer
662 views
What is going wrong with postgresql initdb? Why is the `UTF-8` encoding not getting enforced?
I am using PostgreSQL 9.1. Trying to enforce UTF8 encoding as default.
This is what I am doing.
service postgresql initdb -E 'UTF-8' \
--lc-collate='en_US.UTF-8' \
...
2
votes
1answer
189 views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
1
vote
2answers
169 views
PostgreSQL : Is this because of locks(row level)?
I have a table with approximately 2.1 million tuples. Which has latitude and longitude columns. I am trying to convert this into a geographic type (point with SRID).
The function(procedure) I have ...
0
votes
1answer
117 views
Database designed in facebook [closed]
I want to know which database is used in Facebook?How the database is designed to make virtual friend list in the database of a user?
2
votes
1answer
2k views
Is it possible to do a datapump import with a different user than did the export?
I have one db dump below is the log file for that dump
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** ...
-3
votes
1answer
213 views
Single query to copy data from 3 tables into a single empty table
In an interview today, I was asked if I could write a single query to copy data from 3 source tables to an empty destination table.
I started saying "I will use a temp table or table variables", ...
2
votes
0answers
141 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
2
votes
2answers
233 views
Help with Vehicle Service database
I am using the Desktop Vehicle Maintenance template in access, but i am trying to cater it towards our farms needs.
We will be keeping track of the service's done on Trucks, Tractors, Equipment, etc.
...
0
votes
1answer
193 views
Unable to restore database in Oracle 10g
I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message.
...
0
votes
0answers
124 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
6
votes
3answers
162 views
Can I check the services currently running through SSMS?
I want to check which services has started and which has not by running a script/query on SSMS.
3
votes
1answer
149 views
Can I check what the allocation unit size is on my drives via a query?
Assuming that I do not have access to windows server, can I run a script from SSMS that would allow me to check whether allocation unit size is formatted with 64K?
9
votes
1answer
332 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
1
vote
2answers
696 views
Unable to mount oracle instance
I am trying to shutdown the system, then I want to mount it. I have tried this:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
...
2
votes
1answer
173 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
3
votes
2answers
1k views
pt-table-checksum help required
I am trying to figure out pt-table-checksum, as I am using it for the first time.
It look likes the documentation is complex and not easy to understand stuff.
I have a complex replication topology ...
4
votes
1answer
1k views
Capabilities of InnoDB INSERT Performance
Hi I am running the most recent version of Percona Server.
Server version: 5.5.24-55 Percona Server (GPL), Release 26.0
I have a 10 cpu box of these characteristics.
processor : 0
vendor_id ...
3
votes
1answer
59 views
Administration of MySQL Users
What is the best practice for keeping and maintaining MySQL users? Say for example I have 5 programmers and a PHP application connecting to a database. Should I create 6 different users 1 for each ...
2
votes
2answers
95 views
which option is better for not slow down the performance of queries?
I am developing a system that records customer payments, when a customer makes a payment, the system must update the account and show the payment made and all previous payments, is here when the ...
-1
votes
1answer
164 views
What exactly is SOLR? [closed]
It seems like a magical technology that can
Do spatial search
do full text search
The problem is,
It doesn't say where does it store all the data. Does it have it's own proprietary database
If it ...
0
votes
2answers
221 views
DBA to work from home [closed]
I was wondering is it feasible or doable to work from home as a DBA or Database designer/developer or Business intelligence developer.
I have seen developers doing great working from home, but can ...
2
votes
0answers
210 views
SQL Developer Data Modeller and Data Dictionary question
I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please?
I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
0
votes
1answer
150 views
What are commonly used database types? [closed]
There are a lot of database types. Can you list a list of the top classification of databases commonly found in schools and offices? Any help is appreciated. Hope to see compressed and summarized type ...
0
votes
0answers
379 views
How much does a Junior Oracle DBA get paid? [closed]
I have a pretty good background in programming (SQL/PL-SQL/DB Design/Modeling) and in computers in general... no actual DBA experience (yet!) wondering roughly how much jr dbas get paid ?
It seems ...
3
votes
2answers
257 views
What exactly is “pinning” in relation to indexes?
When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions.
It is part of a test question, where ...
1
vote
1answer
66 views
Clarification on Cloud Computing Database
This question can be very generic, but I am trying to understand the concept of Cloud Databases.
Let's say I have a Web Application, a Desktop Application, and Apps for my Web Application.
All of my ...
5
votes
1answer
405 views
Stored Procedures Best Practices: Fenced or Unfenced?
I believe I understand the reasons behind fenced and unfenced stored procedures.
Fenced run "outside" of the database (in our case DB2) so as to prevent possible corruption of the database engine ...
1
vote
1answer
57 views
Oracle DB administrator-specific security features
Yesterday I was presenting an internet banking solution to a potential client management. My offer is based on using MS SQL Server 2008 RDBMS.
One of the client's officers mentioned, that Oracle's ...
3
votes
1answer
79 views
Inconsistent information from different DMVs
I've a server with 12 GB of physical RAM. I just lowered its 'Max Server Memory (MB)' setting from 10 GB to 8 GB.
If I look at the processes' committed memory in Perfmon, I see:
select *
from ...
6
votes
3answers
1k views
Database Administrator vs Database Architect?
In terms of job responsibilities and activities, what is the difference between a Database Administrator (DBA) and a Database Architect?
2
votes
3answers
209 views
MySQL - Master/Slave Replication with different server specs
I have a Master/Slave replication (using MySql 5.1 / InnoDB).
Currently both my master & slave are running on the same type of server (32 GB RAM, 2 x Intel Xeon 5520 Quad Core 2.26 GHz (8 cores)) ...
0
votes
3answers
1k views
What is the purpose of having a table NOT LOGGED INITIALLY
I came across this recently. When defining a table in DB2 LUW (at least 9.5 or higher), you can define it as NOT LOGGED INITIALLY.
Example from the book I read:
CREATE TABLE products (
productID ...
-2
votes
1answer
194 views
Sharing MS Excel Sheet over network? [closed]
Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode Scanners? The scanner's should dump their Data in the MS Excel ...
0
votes
1answer
75 views
What are the challenges of administrating an International stock trading database?
I am a student, and have a question for an assignment:
What problems and challenges do database administrators face when designing systems to trade international stocks in real time and 24 hours a ...
2
votes
0answers
573 views
823 errors on tempdb
Have a couple Fiber channel SAN-attached cluster servers which have been intermittently reporting errors like:
2012-05-09 16:31:54.13 spid74 Error: 823, Severity: 24, State: 2.
2012-05-09 ...
2
votes
2answers
1k views
Why can the SA account no longer access the master database?
I'm somewhat stuck. We have a database server which was set up and configured by a third party. It's for a third party product so unfortunately we're stuck with the way they've configured it.
Their ...
0
votes
1answer
147 views
RAID vs Replication [closed]
I'm kind confuse about it, can some one give me a hand with this...
Differences.
Which one is better.
Which one do you use and why?
Personal Opinion and advise.
2
votes
2answers
532 views
Cannot login to Oracle11g with System username
I just installed Oracle 11g into my machine.
I was about to shut down a database instance, and Oracle asked me for username and password, I provided the credentials I used to login into the web ...
4
votes
1answer
434 views
Mongo Collection `Size` is *larger* than `storageSize`?
I recently compacted my collection using the command:
db.<collectionName>.runCommand( "compact" )
And now my collection size seems to be bigger than size on disk!
SECONDARY> ...
2
votes
1answer
81 views
database connection time expired issue
I have a server machine and four client machine for database connectivity.
I installed sqlexpress 2008 in server and one machine and all remaining systems, they have connected the database through ...
0
votes
1answer
49 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
8
votes
2answers
1k views
Handling growing number of Tenants in Multi-tenant Database Architecture
Handling a modest number of customers (tenants) in a common server with separate databases for each tenant's instance of the application is relatively straightforward and is normally the correct way ...
4
votes
1answer
121 views
Is there a standard approach to rolling out database schema changes?
A developer said I should simply wrap all my database upgrade scripts in a transaction. If it fails, just roll back all changes. All my instincts tell me this is wrong, especially when it comes to ...
2
votes
4answers
155 views
MySql Database solution for specific web app problem
Well, I need to create a comment system for posts that people add to my web app. This web app is just like facebook or myspace posts. Users add posts and people can comment on them. But the problem is ...
6
votes
2answers
139 views
Automation of backups of Large Number of Database
In a multi-tenant web application where a database is set up for each tenant, the database can be backed up and restored manually through a fairly conventional approach.
I am considering this type of ...
2
votes
2answers
61 views
Data Backup and Restoring the same if requried in SQL SERVER 2008
In Multi-tenancy , Shared Database Shared Schema.
How to take Tenant level backup and restored the tenant data when required? Can any one guide me or point me to the right direction.
Thanks!!!
NB: ...
5
votes
1answer
3k views
What exactly is binding in DB2?
I recently crossed over from being a Java developer to an actual DBA in our company. I am learning the ropes, so to speak, about being a DBA (which is actually somewhat of a new position for our ...
1
vote
1answer
830 views
How can I move LOB_DATA ( varbinary/image/text) to different Filegroups
LOB_DATA : varbinary(max),varchar(max), image , text columns.
I have 4 tables with large amount of LOB_DATA in it. I would like to move LOB_DATA in these tables to different File group in a different ...
