The tag has no wiki summary.

learn more… | top users | synonyms (1)

1
vote
1answer
34 views

What are the contents of the Headers in Control,Redo log and data file in a typical Oracle DB?

Where can i find the contents contents of the Headers in Control,Redo log and data file in a typical Oracle DB.
1
vote
1answer
293 views

SQL 2005 change IP address and subnet

I have to move few sql servers to a new subnet ( change IP address and mask only ), need to know what should be best practice or correct way of doing this? the sql servers are not in cluster. Thank ...
0
votes
1answer
2k views

Make a copy of database with SQL Server Management Studio Express 2005

I have a database in MS SQL Sever 2005 Express. I need to make a duplicate of it to test some upgrade scripts. I've tried to backup and restore to a new database, and it fails because it can tell the ...
1
vote
4answers
2k views

how to restore my mysql 5.1 on ubuntu 10.4?

I am in big trouble not able to access my mysql server.. after restarting grep mysql /var/log/syslog is showing Jul 30 14:30:23 of-desktop kernel: [ 4763.427066] type=1505 audit(1280480423.517:20): ...
0
votes
2answers
485 views

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online ...
1
vote
1answer
1k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
1
vote
1answer
498 views

Load balancing issue with pgpool2 and postgresql-8.3

I'm using the latest release of pgpool2 on Ubuntu 8.04 with postgres 8.3.11. Replication is working great, but none of my SELECT queries are being load balanced to my secondary server. These are ...
0
votes
1answer
494 views

Connect to and reindex Postgres database with system table errors

I've got a Postgres database that crashed (as well as the disk) and suffered some data errors (per http://serverfault.com/questions/156152/after-db-disk-failure-now-cache-lookup-failed-for-index). ...
0
votes
2answers
683 views

db2 tablespace size and performance impact

Originally when we began moving to db2 LUW we ran into some issues where our tables were too big to fit into the default 4K table space. As a result of "pressure" to get it done we just went with a ...
2
votes
1answer
481 views

How to rename database without first stopping SQL instance to flush connections

Is there a way to force a database into single user mode so a script can be run to rename databases? I find I have to Restart the instance of SQL (to force off any connections from a web app, etc.) ...
3
votes
2answers
234 views

10 Million records = wiped MySQL DB?

So I was trying to load some test data and it appears to have killed my entire database. This is one case where it's great to have backups! They were all plain insert queries, probably about a 900 MB ...
0
votes
5answers
1k views

MySQL privileges - DROP tables, not databases

Can someone help me with privileges here. I need to create a user that can DROP tables within databases but cannot DROP the databases? From what I understand from MySQL docs you cannot simply do ...
0
votes
2answers
892 views

Enterprise level control of ClickOnce product on corporate network with group policy?

Hi there I'm a developer looking at introducing ClickOnce deployment for an internal .NET Winforms application that will be distributed via the corporate network. Currently the product roll out and ...
0
votes
1answer
85 views

Reccomendation for tuning 100's of SQL Databases

I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the ...
0
votes
1answer
71 views

Column locking in innodb?

I know this sounds weird, but apparently one of my columns is locked. select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1; select * from table where type_id = 3 and ...
0
votes
1answer
56 views

How can i see what is locking up a table? [duplicate]

Possible Duplicate: “Delete query” not able to be completed I am trying to delete a single row from the db, but it is not completing,even in 20 minutes.There is no other ...
1
vote
1answer
1k views

Deleting huge chunks of data from mysql innodb

I need to delete a huge chunk of my data in my production database, which runs about 100GB in size. If possible, i would like to minimize my downtime. My selection criteria for deleting is likely to ...
0
votes
1answer
291 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
0
votes
1answer
296 views

how to delete a database manually in oracle?

How do i delete database manually. Is tehre any commands for deleting a database? I usually connect through VNC but its better if there is any command line tool.
1
vote
0answers
423 views

SQL 2008 Database tuning advisor won’t start

For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying: Failed to initialize MSDB ...
3
votes
2answers
444 views

Move a Database that is in restore mode

I have a database which is the recipient of a logshipping process. The database is in 'restoring'. Is it possible to move this database? EDIT Just to clarify what I meant by move. I mean to make a ...
0
votes
2answers
1k views

How should I copy the “mysql” database to my new server using PHPMyAdmin

My new webhosting company has set up a MySQL database for me and it has the tables MySQL and Information_schema already there. I want to copy my existing database from another server (a) to the new ...
1
vote
2answers
969 views

Throttle or limit resources used by a user in a database?

I would like to know how databases (like MySQL) are able to manage per user resources (like Oracle Database Resource Manager does) to be able to have users that may only get resources only when the ...
2
votes
1answer
306 views

Opening an oracle database crashes the service [SOLVED]

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 ...
1
vote
1answer
214 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
519 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
107 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
18k 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
209 views

How much effort is SQL Server 2008 Administration?

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
650 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
888 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
412 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
632 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
3k 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
4k 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 ...
1
vote
8answers
1k views

What's a good free MySQL admin tool?

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
362 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
4k 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
169 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 ...
4
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
1k 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 ...
12
votes
5answers
9k 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
184 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
71 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
657 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 ...