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
2 answers

Why would anyone want to put DB log on a SSD?

I keep hearing about people who want to get SSD for their databases. But instead of putting their tables on SSD, quite often people want to put their DB log on SSD while leaving their tables on regular hard drives. But why would anyone want to do…
Continuation
  • 3,080
  • 5
  • 30
  • 38
3
votes
12 answers

Should I host my Data on the same box that I serve my web pages?

I was listening to Hanselminutes one day and this question came up. Under what circumstances should one separate data from code? For example in one of the systems that I've working on the DB is on the same box that servers web content. In another…
Middletone
  • 219
  • 1
  • 6
  • 13
3
votes
2 answers

Best Mysql DB Engine When Insert update delete query is not made

What should be the best Mysql db engine When query like Update, Insert, Delete are barely made (99% of time are not made) The database has a lots entry mainly numeric data type, the select query are based on conditional statement which compares…
Isdev
  • 207
  • 1
  • 2
  • 5
3
votes
3 answers

Is there a log analyzer that will parse IIS logs into a database that can be viewed?

I am looking for a tool that will dump its findings into an external database, such as sql. It doesnt have to be SQL we just want the data in some form of a database so we can manipulate it.
Brooke Ingersoll
  • 65
  • 6
3
votes
1 answer

Using amazon EBS for storing your database. and increasing the storage space!

Ok so you storage your database on Amazon EBS, when you want to add additional storage, you will need to 1) take a snapshot, then wait forever for it to take the snapshot 2) create a new larger volume from the snapshot, and again wait forever for…
001
  • 491
  • 1
  • 11
  • 21
3
votes
2 answers

What happens to redis when your server runs out of free RAM?

Let's say you're hosting redis on a small server with little RAM. What happens if there's too much data, and all the RAM gets used up? Does redis die? Or does it continue operating?
Alex
  • 8,471
  • 26
  • 75
  • 99
3
votes
4 answers

The database myDb is not accessible. (ObjectExplorer)

I'm developing an ASP.NET MVC3 web app, which connects to a SQL Server 2008 R2 database. Everything was working fine, until I started getting this error: The database myDb is not accessible. (ObjectExplorer) This issue appears also when I try and…
elwyn
  • 141
  • 1
  • 1
  • 6
3
votes
1 answer

Setup game server using amazon web service?

I am relative new to amazon web services (aws). I would like to setup a game server for my next coming project. Basically, I just need a database(mysql) and php to connect to the database, nothing else, just fetching and writing data to database. I…
moderaga
  • 79
  • 2
  • 7
3
votes
2 answers

How can I put mysql databases in different disk partitions (linux - Ubuntu)?

Possible Duplicate: multiple file systems for mysql hi, How can I put mysql databases in different partition (linux - Ubuntu)? Thanks, yosef
Ben
  • 775
  • 4
  • 9
  • 19
3
votes
3 answers

Is 10% too much for autogrow on a 4 GB sql server DB?

I am getting the following error: 2011-03-07 21:59:35.73 spid64 Autogrow of file 'MYDB_DATA' in database 'MYDB' was cancelled by user or timed out after 16078 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to…
ntsue
  • 133
  • 6
3
votes
1 answer

How do I remove an old SQL Server 2008 Express Database Instance

I am trying to restore a database over the existing one. This worked fine in the past, until all of a sudden, it doesnt. I have clearly, in the past, attached the same database file under a different name and it now thinks that restoring a database…
Jimbo
  • 309
  • 1
  • 5
  • 16
3
votes
5 answers

Laptop Backup to the Data Center Without VPN

We would like to backup user laptops to the data center – looking for suggestions/alternatives to back them up to the data center where they don’t have to know about it. Blue sky like to haves: • Don’t want VPN but needs to secure • Admin can…
Sameer
3
votes
2 answers

How to mount an Oracle database to new instance?

I have an instance of Oracle 10g R2 installed on Windows Server 2003. This instance was running a database which does not have any backup. Now the OS went down, could not be repaired, and all I got is the running files of the old instance. How can…
Delta76
  • 485
  • 8
  • 18
3
votes
5 answers

Using MySQL replication to enable a read-only copy of a database in a DMZ

I need to set up a MySQL database instance in a DMZ that is a read-only copy of the live master inside a secure network. MySQL replication seems ideal for this, except that it works by the slave "pulling" changes from the master. This implies that…
mrowe
  • 133
  • 1
  • 4
3
votes
3 answers

Database I/O acceleration using solid state drives

What is the experience improving database performance using solid-state drives (particularly for PostgreSQL databases) such as HP's IO Accelerator? Did you see any marked improvements?
Jesse
1 2 3
…
99 100