Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms (1)

2
votes
1answer
1k views

How to setup two mysql servers in Synchronization mode

Infrastructure I have two database servers, running on two different boxes. One works as a primary database for my web application and other works as secondary database. Secondary data base is ...
0
votes
1answer
42 views

Automatically drop FK's to re-create a table and then automatically put the FK's back

I have a number of incidents where SSMS tells me table recreation is required, even for something simple like making a column nullable. If this table is referenced by FK's, I would ideally like to ...
1
vote
1answer
503 views

Taking SQL Server database ownership after the original owner has left the company

I have inherited administration responsibility for a SQL 2008 R2 server at work. The previous database administrator has left the company, and can no longer be contacted. At this point I have: Full ...
2
votes
1answer
295 views

Why is SQL Server automatically creating an explicit user mapping for my local Administrator account in every new database I create?

If I login to a particular instance of SQL Server 2008 using a Windows domain user who is in the sysadmin role and I create a brand new database via SQL Management Studio, a user in the newly create ...
1
vote
3answers
3k views

How-to manage a MySQL table with over 2 million records

I have an InnoDB table running on MySQL 5.0.45 in CentOS. To make matters worse it is all running in a virtual machine. There are multiple tables that have the probability of exceeding 2 million ...
0
votes
4answers
881 views

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
7
votes
4answers
4k views

Modifying columns of very large mysql tables with little or no downtime

I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
1
vote
1answer
133 views

Are there any pitfalls with having multiple MySQL databases on 1 server node?

I want to prepare my database for sharding in the future. But right now I only need 1 node. What I'd like to do is to shard the database into virtual shards, say 12 shards, and put all of them onto ...
2
votes
1answer
679 views

How to move MySQL partitions from one machine to another?

I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) ENGINE=InnoDB PARTITION BY HASH(tweet_id) ...
0
votes
2answers
590 views

how to reset Joomla admin password from the shell?

any idea how I can reset/change Joomla admin password from the linux command line? I have root access to the box. I don't think I can do it phpMyAdmid way. I don't know where the Joomla db is ...
1
vote
1answer
37 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
414 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
544 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
2k 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
534 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
593 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
818 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
530 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
243 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
1k 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
86 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
102 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
58 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
296 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
303 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
483 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
524 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
1k 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
339 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
221 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
640 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
110 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
19k 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
211 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
705 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
431 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
710 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 ...
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
410 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 ...