Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database]

System that handles large amounts of data in an organised fashion

A database is a system of handling and organising large amounts of data that can be easily created, reference or edited.

SQL (Structured Query Language) is a database computer language that is designed for managing the data in a relational database management system.

Some popular database systems include:

  • FileMaker Pro
  • IBM DB2
  • Microsoft Access
  • MySQL
  • Microsoft SQL Server
1684 questions
3
votes
7 answers

Oracle Vs SQL Server to handle around 6-7 Terabytes of data

I am looking for some valid points to choose between Oracle Vs SQL Server to handle around 5-6 Terabytes of data. This data will get accumulated over a period of 8 Months. Any data older then 8 months is purged out of the database. I am considering…
Bhushan Bhangale
  • 143
  • 1
  • 1
  • 7
3
votes
1 answer

Oracle Database suddenly fills storage device in about 20 minutes

My Oracle instance up on Amazon's RDS filled a 20GB storage in the space of about 20 minutes. I checked all the applications that use this DB and nothing looks out of the ordinary - I can't figure out why this would have happened. See the graph from…
wwarren
  • 264
  • 1
  • 2
  • 10
3
votes
6 answers

MySQL DB Backups: Lockless, Per-Table Restore, MyISAM/InnoDB

The Problem I'd like to implement a MySQL backup strategy on a dedicated server. It has multiple databases on, combined total is about 150GB. Most of this is weighted toward one of the databases. Database is mixed engine MyISAM and InnoDB (plans to…
Chris Rosillo
  • 51
  • 1
  • 3
3
votes
1 answer

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've tried the automatic InnoDB recovery program…
Jonniboy
  • 31
  • 1
  • 1
  • 2
3
votes
8 answers

RAID and Databases

I use Postgresql 8.4 and I wanted to know what type of RAID is mostly used for databases. I read everywhere that RAID10 is the best suited and RAID5 not a good option. ex: http://www.revsys.com/writings/postgresql-performance.html My server is a…
Matthieu
  • 443
  • 4
  • 12
3
votes
3 answers

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you let it sit all day. Even just a check gets hung at…
Tiffany Walker
  • 6,681
  • 14
  • 56
  • 82
3
votes
3 answers

if I select more than 15 fields, I get catastrophic failure

Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it. When I do select * or select field1,field2,field3....field15 I am getting this error: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked…
Alex Gordon
  • 455
  • 3
  • 14
  • 31
3
votes
2 answers

Puppet: how to use data from a MySQL table in Puppet 3.0 templates?

I have some data whose source-of-truth is in a MySQL database, size is expected to max out at the some-thousands-rows range (in a worst-case scenario) and I'd like to use puppet to configure files on some servers with that data (mostly iterating…
Luke404
  • 5,826
  • 4
  • 47
  • 58
3
votes
2 answers

SharePoint database login failure for the computer account

Once an hour I am getting a login failure on the database server for a SharePoint 2003 server. The account(s) that are failing is the domain computer account for each of the web servers and the index server. It happens around the clock and each time…
jt.
  • 341
  • 3
  • 6
3
votes
9 answers

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 (42000): Incorrect database name Thank you for helping.
Rafał Kamiński
  • 187
  • 2
  • 5
  • 15
3
votes
1 answer

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 error may indicate data corruption or that the log…
Velu
  • 171
  • 1
  • 4
3
votes
0 answers

Barracuda SSL VPN Managing Users

Not really sure if this is the right site to be posting on, but I have a question about my Barracuda SSL VPN. I know there is a built-in user database on the VPN. Is there some way (in my asp.net source code) to check what users are logged in to…
CSharpDev
  • 131
  • 1
3
votes
1 answer

Cant open up oracle web console after install db 11gr2 and show weird symbols?

i just finished installing oracle database 11gR2. after successful install, i will usually want to open up web console at http://localhost:1158/em.. however if i open up the page i get a weird symbol on the top left. i also cant login to the db…
Psychocryo
  • 149
  • 1
  • 1
  • 3
3
votes
1 answer

My log file size is 121 GB how to reduce?

We are using Navision 2009 and the database transaction log file has grown to 121GB. We would like to shrink the file. Can this be done?
srinivas
  • 31
  • 1
3
votes
2 answers

Re-assigning raw SAN disks from Solaris to Linux

We have a SYBASE IQ database running on Solaris using raw devices as underlying storage for the database. We would like to migrate this environment from Solaris to Linux. Is it possible to just reassign the SAN disks used as raw devices by SYBASE to…
user126330
1 2 3
…
99 100