The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
2answers
178 views

DB2 users and groups

Just want to know everyone's experience and take on managing users/authentication on a multi-node db2 cluster with users groups. I have 17 apps in production (project based company, only 2 online ...
0
votes
1answer
76 views

Database server setup guide

Is there a good guide to setting up database servers, specifically MSSQL 2008 on Windows Server 2008, in a large organisation? I'm sure I'm able to collect all the information I need myself, but if ...
1
vote
3answers
5k views

Proper Way to Grant Permissions in PostgreSQL

I am new to PostgreSQL and am having a bit of trouble finding any information on how to grant a user permissions on the database that they own. I have read a few sources that says the owner has all ...
5
votes
5answers
2k views

What is “The” book for database design? [closed]

In programming, there is often a canonical book for a particular topic, like the dragon book for compilers, K&R for C, etc. Is their a book regarding modern database design that simply must be ...
2
votes
1answer
2k views

PostgreSQL: Permission to execute function (that inserts into a table) but no permission to insert directly

Sorry if this is the wrong place to ask this question. I have created a function that inserts values into many tables, and I want the web front-end to execute this function. I have granted execute ...
14
votes
5answers
11k views

What's the best way to automate backing-up of PostgreSQL databases?

I find it tedious to have to backup databases every week. And I also think weekly backups should be turned into daily backups. If I had to do that, I don't want to do it manually. What's the best way ...
2
votes
6answers
188 views

mySQL DBA Software [closed]

Are the free mySQL GUI tools adequate for administering a mySQL db running 'vendor' supplied applications? Are there other tools you would recommend that make your life easier?
1
vote
3answers
72 views

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 ...
0
votes
2answers
1k views

MySQl, Postgresql replication comparison

One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag. How does Postgresql handle replication? Does it (or add-on such as slony-I) allow ...
0
votes
1answer
737 views

Configuring MySQL logging for an audited environment such as SOX

How do you configure MySQL users and logging to satisfy SOX auditors? For example, if you need to log queries and the source of the query for later review by an internal SOX controls group. Is there ...
1
vote
3answers
3k views

How do you clone an oracle instance?

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname. I'm working with Oracle 10.2.
2
votes
1answer
2k views

Optimising PHPMyAdmin configuration for massive databases and many tables

Developers require database access to a significant number of databases, each with 220+ tables, and currently they are provided this using phpMyAdmin 2.11.9.5. Initial load is very slow, puts some ...
3
votes
2answers
234 views

How do I connect to a SQL Server on an ISP using SQL Server Management Studio?

It's actually SQL Server Management Studio Express. Do I need the full version? How do I connect?
6
votes
2answers
32k views

Changing database owner in SQL Server 2008; CLR issues depending on method used?

I attached a database and tried changing the owner to a valid login. I used the statement: ALTER AUTHORIZATION ON database::my_db_name TO "sa". The database properties showed that the new owner was ...
0
votes
2answers
4k views

Configuring keepalives with TOAD client communication

I have a scenario where long-idle sessions of TOADSoft client communication with the Oracle server seem to be torn down as they timeout on an intermediate state-full firewall. These sessions could ...
1
vote
1answer
1k views

SQLVDI error - attempt to release mutex not owned by caller

I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however ...
1
vote
6answers
3k views

SQL 2005 Database Not Accessible

I've moved a database from sql 2000 to a new 2005 server. Everything was fine until I logged into Sql Server Management studio with one particular user. It looks like i logged in successfully but when ...
1
vote
6answers
265 views

Should a Database admin need to know all the DB systems out there?

What's the requirement? Where's the boundary? Is there any?
6
votes
4answers
18k views

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and ...
6
votes
5answers
1k views

Updating a MySQL Database

We have an online system using MySQL database. We need to merge an older backed up database (Full tables, not a dump file) with the current one. Without experiencing any server downtime, how would you ...
2
votes
2answers
7k views

Restarting a database in a database instance without restarting entire database instance

I have a database server running several instances of database. I am having issues while accessing a particular database and want to restart the same but without restarting the entire db server as it ...
4
votes
2answers
2k views

Script logon to a 'Cisco' VPN in windows

I would like to sync my development database with actual data from the production databases on a regular basis (say, weekly). I already have the scripts to do this, and the amount of data is not huge. ...
0
votes
1answer
817 views

Progress 8 database on Unix to OpenEdge 10 on Windows?

Is it possible to upgrade a Progress 8 database to a OpenEdge 10 database, when the operating systems differ? Progress database files from version 8 need to be upgraded to version 9, and then to 10 ...
47
votes
9answers
57k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
4
votes
4answers
7k views

Can you explain exporting and then importing ProgreSQL using phpPgAdmin? (And what's with permissions?)

Bounty Edit: I've left the original question but would like a good answer on the whole permissions debacle that Postgres seems to bath in. 'Importing & exporting clients db's: A field guide' I ...
3
votes
4answers
221 views

How many Database accounts

How many user accounts should be setup for a given application? Where should the separation be? Should it be one login per application? 1 Application per program? 1 for front end and backend? ...
5
votes
7answers
8k views

How to optimize performance for MSSQL databases?

I'm a dba with a database with ~280 tables, and total datasize of ~1,5GB. I'd like to tune the database to make it perform better. What do you do to keep your SQL databases performant? How much ...