The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
424 views

Opening an oracle database crashes the service

I am experiencing a weird issue with Oracle where the service started fine after a crash. The database mount went fine as well. However, when I issue alter database open; command, the database does ...
2
votes
2answers
1k views

SQL Server 2005: Rename DB Server Instance Name?

Can somebody tell me how to rename the DB server instance name and a DB name in SQL Server 2005? Right Now I Have SERVER/OLDNAME -- oldnameDB I want to change the server instance and also change ...
2
votes
1answer
229 views

MSSQL Replace Database in Live Web App

I have a web app that is currently live. I had the need to make major modifications to the database and now I need to replace the current one. My dev SQL instance is not the live one. I usually ...
1
vote
3answers
914 views

SQL Server 2000 need to prevent logons whilst performing a backup for a side by side migration

I'm looking for a way to prevent logons from occurring in order to take a full backup of a Database to migrate from its current SQL Server 2000 instance to a new SQL 2005 instance. A friend of mine ...
6
votes
2answers
116 views

What are the basic tasks that need to be done to keep an SQL Server 2005 database healthy

I have a SQL Server 2005 database that is large in every sense. It is complex, it has a lot of data (relatively, but given the lack of blobs, it is still quite large) and it is heavily accessed. What ...
2
votes
5answers
24k views

How can I synchronize MS SQL Server databases?

How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
7
votes
5answers
221 views

How much effort is SQL Server 2008 Administration? [closed]

I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary ...
1
vote
1answer
838 views

SharePoint split content database - mergecontentdbs

I'm splitting a SharePoint content database and running into a problem with the stsadm mergecontentdbs command. I'm pretty positive it is an error in my command, which is as follows: stsadm -o ...
0
votes
1answer
1k views

How to DENY access for a particular database for login “sa” and grant access for another login? (SQL Server 2005 Express)

I have the SQL Server 2005 Express edition with "Mixed Mode authentication". So I want to create a database called "ActivityLogs" where I want to DENY access for the "sa" login. I want to create ...
0
votes
1answer
466 views

SQL SERVER Express Connection String for User Instances same on SQL Server Standard

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access: Data Source=.\SQLExpress; AttachDbFileName=...
0
votes
2answers
866 views

Is it safe to set MySQL isolation to “Read Uncommitted” (dirty reads) for typical Web usage? Even with replication?

I'm working on a website with typical CRUD web usage pattern: similar to blogs or forums where users create/update contents and other users read the content. Seems like it's OK to set the database's ...
0
votes
2answers
5k views

How do I configure SQL Server to name database backup files by date or other pattern?

When SQL Server 2005/2008 database backup jobs are run from Maintenance Plans, can they be configured to include some sequence number (or other indicator) in the filename, so that previous files with ...
0
votes
2answers
6k views

How to change the default instance of SQL Server?

we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance. Nowadays we barely use the SQL2000 instance, but this is the default. We ...
3
votes
4answers
2k views

Using linked servers to query across database servers?

We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The ...
2
votes
8answers
2k views

What's a good free MySQL admin tool? [closed]

I'm looking at phpMyAdmin to manage users and create the database in the first place. Is it the best thing to go for, or are there other packages that are not web based that might be faster or better? ...
1
vote
2answers
532 views

How to restore just ONE mysql database from a collective backup

I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file. How can I tell mysql to import ONE of the databases contained in the dump file? -M ...
1
vote
2answers
5k views

Unable to back up SQL Server databases using a maintenance plan

I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select ...
0
votes
2answers
184 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 apps)...
0
votes
1answer
78 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
4k 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
3k 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 ...
16
votes
5answers
16k 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
189 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
73 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 ...
7
votes
11answers
1k views

When is it worth getting a DBA?

I've now worked at a few tech companies ranging from 10 people to ~150 and I've never encountered a real DBA. How big does a company need to get before it merits getting a DBA? What are the criteria ...
0
votes
3answers
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 multi-...
0
votes
1answer
806 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 ...
2
votes
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
249 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?
7
votes
2answers
34k 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 '...
1
vote
3answers
5k 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
271 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
19k 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
2k 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 ...
3
votes
2answers
12k 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 ...
2
votes
1answer
679 views

Alternatives to Zmanda for MySQL backups?

I don't have a problem with Zmanda but i wonder if there is any better or popular solutions out there other than doing it by hand. My requirements are: Online backups The tool should decide to use ...
10
votes
13answers
5k views

Linux knowledge a Junior cannot miss [duplicate]

Possible Duplicate: What a beginner should know/learn for sysadmin job? I am soon going to be graduating from college, and am looking for job offers right now. There is one that I have a lot ...
2
votes
5answers
471 views

revision control for database schema and configuration [closed]

What are the best practices for managing revisions to the database schema and configuration ? what tools do you use ? Michael
12
votes
6answers
6k views

How do you interview a Database Programmer/ Admin applicant?

During the interview, I ask basic database design questions. Normalization (When-Why) is one of my concerns when it comes to database design. Some scenarios I site that involves synchronized servers ...
12
votes
8answers
12k views

Any good PostgreSQL client for linux? [closed]

stackoverflow points me "belongs-on-serverfault" on this, so crossposting. I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL. pgAdmin III is buggy ...
4
votes
2answers
3k 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
962 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 (...
65
votes
10answers
87k 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 ...
2
votes
10answers
2k views

Things every DBA for DB2 on Unix, Linux should know

What are the most useful resources for a DB2 DBA working on Unix or Linux? Books Web sites Tools etc.
5
votes
4answers
8k 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
222 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? ...