The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
746 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
446 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; ...
0
votes
2answers
794 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
4k 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
5k 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
1k 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
521 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 ...
0
votes
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
181 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 ...
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 ...
16
votes
5answers
12k 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
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 ...
7
votes
11answers
936 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 ...
0
votes
1answer
759 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
239 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
33k 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
267 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
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
9k 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
869 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 ...
56
votes
9answers
66k 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
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? ...
5
votes
7answers
9k 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 ...