The database-administration tag has no wiki summary.
1
vote
3answers
69 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
59 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
40 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
45 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), ...
1
vote
3answers
51 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.
0
votes
0answers
45 views
sybase bcp import fails
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below).
We ...
1
vote
2answers
40 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
74 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
93 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
53 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 alot of data in ...
3
votes
2answers
108 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 ...
0
votes
2answers
52 views
RDS or AQL Azure, which one do you recommend?
I have developed a web applicaiton that does soem heavy DB work. I have developed the application using ASP.net and SQL Server 2008 Express. I wanted to know which service I should use, Amazon RDS or ...
-1
votes
1answer
49 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
62 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
67 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
74 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 ...
0
votes
0answers
26 views
Green Plum -Eror unable to write on pg_distributedlog\000A no space in disk
im wroking on Greenplum database bt while Loading huge volumme of Data through ETL
i got a strange error
unable to write on pg_distributedlog
with this error im unale to acces my pg_client in order ...
1
vote
1answer
154 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
57 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 ...
0
votes
1answer
108 views
Alternative to phppgadmin?
While trying to manage some PostgreSQL databases, I've ran into a rather peculiar problem with phppgadmin:
It is slowly (and occasionally not so slowly) eating away my last strands of sanity.
I ...
1
vote
3answers
126 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
41 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 ...
1
vote
2answers
221 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
40 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
55 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 ...
0
votes
3answers
97 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
73 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
123 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
55 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
2answers
62 views
clustering MS SQL 2008
I have a Project in DBMS just I need something like a BIG TITLES of What TO DO.
Here a brief way about the Project:
Install 3 WIN2K8 R2 one of them domain controller (easy)
On non DC nodes, install ...
0
votes
1answer
73 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
62 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 ?
# ...
0
votes
2answers
358 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 ...
2
votes
3answers
110 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
67 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
53 views
What's the best tool for managing database evolution/versioning?
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
62 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
49 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
3answers
169 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
343 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
160 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
3answers
141 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 ...
1
vote
1answer
107 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
83 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
170 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 ...
1
vote
3answers
528 views
MySQL maintenance - how to clear the buffer?
We have a server running our web app (PHP / MySQL) which is SLOW.
My predecessor says that:
"We use to do database maintenance, which use to clear the buffer, cached and unwanted variables."
And I ...
0
votes
1answer
78 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 ...
0
votes
1answer
374 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
275 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
77 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?
