The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
2k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
2
votes
1answer
56 views

Consolidating SQL Server

We have a number of SQL Server 2008 R2 standard servers, each for a single application that we'd like to consolidate into one physical server. Running perfmon on these servers they're not using a ...
1
vote
3answers
2k views

Can we restart a SQL Server instance remotely?

I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled I am connecting ...
0
votes
1answer
248 views

Scripts to automate maintenance on thousands of databases?

We have a web application that, for government-regulated security reasons, requires each client to have their own database. As a result, we have a few thousand small databases that all have the ...
0
votes
1answer
83 views

How to set backup / database in order to maintain heavy write loads

I have a write heavy application. Approx 5lac+ inserts per day in a MySQL table. I have master <> master -> slave. Performance is not an issue here. I need your inputs with regards to management ...
0
votes
1answer
627 views

How often would you run the Postgresql maintenance tasks

After reading the Postgresql documentation, we found that it's recommendable to run the Vacuum tasks daily: We recommend that active production databases be vacuumed frequently (at least nightly), ...
2
votes
3answers
748 views

How to share a SQL DataBase over the internet?

According to the above figure how can I share a database over the internet that is hosted on a server and allow a remote PC to connect using its static IP and using a connection string.
1
vote
2answers
97 views

Sql Server 2008 R2 connection error

I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client. But it shows the following error: cannot connect to SMSERVER\SMTECH How ...
0
votes
2answers
220 views

Curious about my database server setup

I'm a web developer by day but I haven't had as much server administration experience as I'd like. I'm working on some side projects which are hosted on a 512mb linode server. The main app that I'm ...
2
votes
1answer
3k views

Adding Domain Admin as a SQL Server admin

I inherited a domain with a SQL Server where nobody knows password to it's admin login. I have full rights on the domain and that server, is there a way to get access to the SQL Server instance?
0
votes
1answer
162 views

copy a MySQL table which has data in ibdata file

I have a database in MySQL with several tables. Some of the tables only have .frm files. Some have .frm .mdy .mdi I believe data for the .frm tables is in the ibdata file. There is a lot of data in ...
3
votes
2answers
684 views

Online Schema Change Strategies for Large MySQL Tables

I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of ...
-1
votes
1answer
69 views

Linking LDAP with other databases — design considerations [closed]

There's a company X (a call center) with about 300 workstations and a task to implement LDAP for user authentication. Fine. We put non-volatile user information (UIDs, e-mails, first and last names) ...
0
votes
2answers
107 views

Move SQL Server Databases to new installation

I am reinstalling Windows on a developer workstation, that runs SQL Server 2008R2 and contains a lot of SQL Server databases (~50). After the reinstall, I want the SQL Server up and running with the ...
0
votes
1answer
216 views

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app ...
0
votes
1answer
140 views

Backup SQL Server database to local machine

I'm connected to the remote database using SQL Server Management Studio 2008. I'm a little bit limited for space on my server, so I just want to do a backup to an external drive connected to my ...
1
vote
1answer
506 views

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql ...
1
vote
2answers
798 views

SQL Server variable size and increase it

It is not clear to me how a varchar(max) is declared or used in an SQL Server e.g. 2005 Is a variable declared as varchar(300000) for example considered as a varchar(max)? E.g. I am seeing in a DB in ...
1
vote
3answers
177 views

What database backup utility should I use?

Can anyone recommend a database backup utility, free or paid? Ideally it will backup MSSQL & MySQL, but MSSQL only will suffice allow backup of single tables encrypt backups Many thanks
0
votes
1answer
80 views

Validate SQL Server partitions and filegroups

Information: I took over a SQL Server 2005 that the previous DBA had configured three filegroups to segregate the data onto unique LUNs: G: Data (Primary) F: Audit J: Index However, the ...
8
votes
2answers
3k views

With MySQL, how long does an “ALTER TABLE … DISABLE KEYS;” statement last?

If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last? For a query like: ALTER TABLE users DISABLE KEYS; Do the keys get re-enabled at the end of ...
0
votes
1answer
124 views

Managing multiple storage volumes in Microsoft SQL Server

I have a backup application backed by many databases (one per client) in Microsoft SQL Server, storing files in the database as BLOBs. We are looking to move this application to Amazon EC2, and ...
1
vote
1answer
98 views

Does MS SQL 2005 encryption protect data in the case of physical server access?

I am looking into MS SQL 2005 encryption (not 2008, so TDE is out), and I believe I understand the concept of how a column is encrypted. The OS uses the service credentials to encrypt the service ...
1
vote
5answers
2k views

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan ...
4
votes
3answers
603 views

Naming convention for databases and database users for access by a web application?

When installing a web application where a single user is used to talk to a single database (say MySQL, but this could apply to other RDBMSes also), you often have a sequence of events such as this: ...
0
votes
3answers
237 views

Finding an optimal balance of I/O, CPU, and RAM for MySQL

For a long time I’ve wanted to know how MySQL scales as you add more memory to the server.We looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, ...
0
votes
2answers
228 views

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. ...
1
vote
1answer
79 views

clustering MS SQL 2008 [duplicate]

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the ...
0
votes
1answer
131 views

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity ...
0
votes
1answer
136 views

Mysql slow query log issue…?

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ? # ...
5
votes
2answers
7k views

How well does PostgreSQL perform with a large number of databases?

We have an web application whose architecture requires that any registered user (a company, actually) should be isolated from the other, i.e., I'll run the same webapp with the same data models, but ...
7
votes
2answers
4k views

After setting root password why does MYSQL still allow me to login without a password?

After setting root password why does MYSQL still allow me to login without a password from the command line? I can type "mysql" at a root unix prompt and it asks for no password and still allows me ...
0
votes
1answer
140 views

What are the dangers/consequences of reducing the SharePoint_Config_log database?

I have used DBCC ShrinkFile on a SharePoint_Config_log database and I'm wondering what the consequences of this action may be? The log file was growing upwards to >11 GB for an 8GB database and space ...
1
vote
3answers
121 views

What's the best tool for managing database evolution/versioning? [closed]

We need a tool for dealing with database evolution/versioning. And we need the best! :) Can you expert guys help us to find a great tool that has these features? Conceptual Model: The tool must ...
1
vote
1answer
123 views

Oracle EE 11.2g: how to generate fresh new redo logs

In the company I work for we are heavy users of VMware machines. Almost all our projects are developed inside a virtual environment up to the point where we have to deploy them into a production ...
1
vote
1answer
89 views

What's the best way to split client sites in a PostgreSQL installation?

I need to host several client sites using one PostgreSQL installation. What's the best way to split them -- by schema or by instance? The factors would be what makes admin easier (especially ...
3
votes
4answers
636 views

Best practices for SQL Server audit trail

I'm facing a situation today where it would be very beneficial to me and my company if we knew who had logged into SQL and performed some deletions. We have a situation where at least 2 (sometimes 3) ...
0
votes
1answer
3k views

On MySQL 5.1 for Windows, why can't I assign DBA role to the “root” user?

On MySQL 5.1 for Windows, why can't I assign DBA role to "root" user? The MySQL Workbench allows me to add all the other roles except for DBA. Also, when I "alter schema" on any table, while ...
0
votes
2answers
321 views

What Could Be Causing MySQL To Crash On A Read Query?

So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs. I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said ...
0
votes
2answers
830 views

How to do MySQL Maintenance especially after disk is full

I have a quite large mysql database (InnoDB) running on ubuntu server virtual machine. Recently due to my fault the hard drive became full (on the physical machine) and the server got stuck and users ...
3
votes
2answers
3k views

Why is my database not available?

I have one database on my server that constantly becomes unavailable. To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open ...
1
vote
2answers
175 views

Linux: How to rename old mysqld when upgrading MySQL?

I'm upgrading MySQL from MySQL 5.0 to Percona Server 5.1. I'm planning to just use yum remove and yum install to do the upgrade. However, I read in the documentation that it's a good idea to rename ...
1
vote
1answer
3k views

What is the best way to determine what's locking up SQL Server using a query?

Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so ...
2
votes
3answers
6k views

MySQL maintenance - how to clear the buffer?

We have a server running our PHP/MySQL-based web application which is SLOW. My predecessor says: We used to do database maintenance, which used to clear the buffer, cached and unwanted variables. ...
0
votes
1answer
2k views

SQL 2008. How to let user to create/alter sprocs in only one particular schema?

I have a user which can read and write but now he needs to be able to create/alter a sproc but giving him ddl_admin will make it too unsecure. I dont trust him that much. What can I do about it? Can ...
1
vote
1answer
3k views

Cannot open DTS packages in SQL 2008 x64

We are deploying a new MS SQL 2008 R2 x64 server running on Win 2008 R2 x64. We need to open DTS packages but receive the error: "SQL Server 2000 DTS Designer components are required to edit DTS ...
0
votes
1answer
3k views

Easiest way to export functions from a MySQL DB

I am migrating a bunch of changes from our dev database, consisting of some extra tables, the data from a subset of these tables, and some new functions. Using phpmyadmin I have exported the structure ...
0
votes
1answer
449 views

Can MySQL use roles without MySQL Wokbench?

I have only found documentation about roles in MySQL through the use of Workbench, is there an alternative way to set them?
1
vote
2answers
406 views

SQL Server Replication Backup

We have a new system that runs on SQL Server 2008 r2 64-bit. There is a primary on-line transactional processing (OLTP) database that accepts a high volume of updates from several thousand Point of ...
0
votes
3answers
731 views

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the ...