The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
351 views

Database maintenance plan fails to run everytime

I currently setup a DBMP for SS2008 and i explicitly set it to run under a user that is the the serveradmin role. Also in the job (under sql server agent) generated from the above plan is set in the ...
0
votes
1answer
214 views

long dataset of small rows — infrequent writes, very frequent reads — what's the best platform?

A part of the platform I am building requires a large data table (starting at tens of millions of records, scaling to hundreds of millions within a year or two, maybe reaching billions at some point). ...
1
vote
3answers
227 views

How to automatically move specific MySQL tables from one machine to another?

I have a MySQL database with tables in the form of "shard_0", "shard_1", "shard_2", etc. I want to add another DB server and move the even-numbered shards ("shard_0", "shard_2", "shard_4", ...) to ...
0
votes
1answer
468 views

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a ...
1
vote
2answers
6k views

Any way to copy the schema from one MySQL database to another?

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to ...
0
votes
1answer
401 views

SQL Database Admin or Developer?

Can someone explain the main difference between each? Which one do you consider more difficult? Which one is it easier to find and maintain a job? Im trying to start the first stepping stone of doing ...
6
votes
3answers
8k views

Becoming a DBA, what do I need to know?

Im sure this has been asked, but times change and so do SQL preferences etc... I figure this place would be the best place to ask this im sure many DBA's come here. But what do I need to know ...
14
votes
1answer
24k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
3
votes
3answers
4k views

Shrink SQL Server data file, but not all at once?

I have a database file that's currently 150GB, but only 75GB is being used - it's because I moved all the indexes (the other 75GB) to a new data file. I'd like to reclaim at least part of the space ...
0
votes
1answer
130 views

SharePoint admin configuration inaccessible

I successfully moved three out of four SharePoint Service databases from one database server to another, except for the admin content database. Now I am unable to access the Admin Configuration on ...
2
votes
1answer
2k 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
43 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
627 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
417 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
4k 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
1k 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
6k 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
144 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
859 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
713 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
621 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
653 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
562 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
756 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
1k 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
619 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
246 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 ...
1
vote
5answers
2k 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
158 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
60 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
2k 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
300 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
313 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
543 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
691 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
2k 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
391 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
224 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
779 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
113 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
22k 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
217 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 ...