Questions tagged [database-administration]
The database-administration tag has no usage guidance.
296
questions
1
vote
3
answers
13k
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 ...
CommunityBot
- 1
0
votes
4
answers
3k
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?
- 249
1
vote
1
answer
4k
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 ...
- 1,908
3
votes
1
answer
1k
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 ...
- 27.2k
6
votes
4
answers
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 ...
- 38k
1
vote
1
answer
163
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 ...
- 8,927
2
votes
1
answer
2k
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)
...
- 3,130
1
vote
1
answer
1k
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 ...
- 69.1k
1
vote
2
answers
8k
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 ...
CommunityBot
- 1
1
vote
6
answers
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 ...
CommunityBot
- 1
0
votes
1
answer
3k
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 ...
- 4,679
0
votes
1
answer
2k
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 After DB disk failure, now "cache lookup failed for index").
The initial problem seems to ...
CommunityBot
- 1
2
votes
1
answer
1k
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.) ...
- 2,196
3
votes
2
answers
271
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 ...
- 663
0
votes
2
answers
3k
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 ...
CommunityBot
- 1
0
votes
1
answer
835
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 ...
- 419
0
votes
1
answer
79
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 queries ...
CommunityBot
- 1
1
vote
1
answer
4k
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 ...
- 24k
0
votes
1
answer
406
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.
- 211
4
votes
2
answers
2k
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 ...
CommunityBot
- 1
1
vote
0
answers
644
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 ...
- 133
2
votes
1
answer
256
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 ...
CommunityBot
- 1
2
votes
2
answers
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 ...
CommunityBot
- 1
1
vote
3
answers
1k
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 ...
- 2,022
6
votes
2
answers
129
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 ...
- 1,899
1
vote
1
answer
937
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 ...
- 11.2k
0
votes
1
answer
2k
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 ...
- 8,303
0
votes
1
answer
491
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=...
- 38k
0
votes
2
answers
7k
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 ...
- 1,262
1
vote
2
answers
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 ...
- 247
0
votes
1
answer
83
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 ...
- 7,257
1
vote
3
answers
7k
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 ...
- 279
1
vote
3
answers
94
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 ...
CommunityBot
- 1
5
votes
1
answer
8k
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 ...
CommunityBot
- 1
0
votes
1
answer
941
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 ...
- 162
7
votes
2
answers
36k
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 '...
- 109
2
votes
3
answers
4k
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.
- 166
2
votes
1
answer
3k
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,922
3
votes
2
answers
470
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?
- 4,437
3
votes
4
answers
240
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?
How ...
- 14.7k
1
vote
6
answers
303
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?
- 38k
6
votes
5
answers
3k
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 ...
CommunityBot
- 1
10
votes
13
answers
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 of ...
CommunityBot
- 1
3
votes
2
answers
23k
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 ...
- 7,194
5
votes
2
answers
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. ...
- 241
6
votes
7
answers
15k
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 ...
- 1,666