The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
37 views

Installing MS SQL Server 2008 R2 Utilizing Data Array

Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right. I have a new server that has Windows Server 2008 R2 loaded onto a RAID ...
2
votes
2answers
264 views

What tool generated this report of MySQL server performance?

I found this report on the performance of a MySQL server. I would like to be able to generate this report for my own server, but I don't know what tool they used. Does anybody recognise this report? ...
1
vote
0answers
28 views

Move one site in Wordpress Multisite setup

I have a Multisite Wordpress setup with a dev box and a live. Whenever my developers change a theme on one of the sites or add a page/post/any other content on the deb box, I have to take the whole db ...
1
vote
2answers
261 views

Low priority batch processes on live Mongo database

We want to run MapReduces on our live Mongo database, mainly so that we can extract metrics. However, we've had some bad outages caused by these MRs bogging down the Mongo server (in particular 100% ...
0
votes
1answer
42 views

DB Migration switching from MySQL [closed]

I currently have a massive MySQL Data but would like to move over to Cassandra nosql. How hard of a move over would this be? I've not found any examples yet on this being done. It is possible right.
1
vote
1answer
2k views

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This ...
2
votes
1answer
234 views

Using mongodump with an auth enabled mongodb server

I'm trying to do a daily backup of my mongodb server (auth enabled) using the mongodump tool. mongodump provides two parameters to set the credentials: -u [ --username ] arg username -p [ ...
1
vote
1answer
124 views

Are there measurable benefits to running XFS on EC2

I am looking at creating a PostgreSQL database image (to run on Amazon EC2) and I have heard good things about XFS. However, since ultimately you are running in a VM, the gain of XFS on EC2 might ...
0
votes
1answer
102 views

All users can read SSAS all Cubes

I found that all my domainusers can read the cubes in my Microsoft Analasys Services. I have no roles specifying that. Neither the domain admins nor the local admins contain any group that would ...
5
votes
4answers
525 views

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that ...
2
votes
3answers
267 views

How to change default recovery for new databases?

How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default? Currently if we remember, when creating a ...
1
vote
1answer
108 views

Table Space and Data Sized increased multiple times after power failure

We had a total power failure on our 2 node cluster using SQL Server 2008 (10.0.2531) Standard Edition. After recovery, everything is running fine. One issue I discovered is the Table Size and the Data ...
0
votes
1answer
331 views

MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS

I will be uploading a web application to amazon ec2 instance in the next couple of weeks. I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS. The only confusion i ...
5
votes
2answers
3k views

Can't Login to phpPgAdmin

I'm trying to set up phpPgAdmin on my test machine so that I can interface with PostgreSQL without always having to use the psql CLI. I have PostgreSQL 9.1 installed via the RPM repository, while I ...
2
votes
1answer
61 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
0
votes
1answer
58 views

Index Proposals

As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
0
votes
0answers
5k views

can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)

I'm having the error 'can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (2)' when trying to log into mysqladmin and my sites have database connection errors. Here's the ...
3
votes
1answer
2k views

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ...
1
vote
2answers
175 views

create a 'definition' file from Oracle

I have inherited an oracle database, and have no Oracle experience. I have been tasked with building a 'clone' of the database on a new server. I am searching around, but not finding the things I am ...
1
vote
4answers
624 views

How to load large SQL file into mysql

I have a database backup of a MySQL database that is about 250MB. I made it with mysqldump I was trying to load it on another server like so: mysql -u xxxx -pxxxx data_mirror < dbdump.sql I was ...
1
vote
1answer
229 views

MySQL connection issue with error 2003 / 111

I'm running a mysql server using the following command: mysqld --no-defaults --user=root --port=3310 --bind-address=0.0.0.0 --skip-grant-tables & My understanding is that this command starts ...
0
votes
1answer
159 views

ASP.NET Application Connection String and SQL Server Security / Permissions

I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company ...
2
votes
1answer
28 views

Formatting data from management database

I've got some data that goes like this: Config_Name Question Answer Cisco WAN Sensitivity: High Cisco WAN Authorized Users: Brent, Charles Cisco WAN Last Audited: n/a ...
4
votes
2answers
296 views

MySQL 5.5.16 allows anonymous connections

Apparently, I can connect to MySQL (at least from my localhost) without having to provide any username or password. I can even put anything as username, as long as the password is empty. I have access ...
1
vote
2answers
352 views

[MySQL]multiple-masters single-slave

Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ? If yes, how to do it ?
1
vote
5answers
446 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
0
votes
3answers
314 views

Mysql Slow queries log

Is their any way to filter mysql slow queries database specifically from /var/log/mysql/mysql-slow.log file. I have a mysql server with 5 live databases. I am trying to optimize this server. Also I ...
1
vote
1answer
780 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
52 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 ...
0
votes
0answers
57 views

Maintenance plan on databases fail because of file level locking on db's

We are running a shared SQL server with a maintenance plan that is scheduled to run every night. The maintenance plan does reindexing on all db's but the maintenance plan now throws an error because ...
1
vote
3answers
970 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
235 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
80 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
327 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
222 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
84 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
210 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
320 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
149 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
464 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
104 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
158 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
124 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
463 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
491 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
171 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
68 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 ...
3
votes
2answers
2k 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
101 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 ...