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
0
votes
1 answer

How do I convert .DAT and .XML dumps into a readable database?

I have a program that keeps all data in a Derby database. The application itself has crashed but the company that supports the software has a utility that can sort of recover the database. I was sent a zip files containing one schema XML file and…
Juice
  • 135
  • 10
0
votes
3 answers

When is database clustering the best option?

I have 2 servers. They both host identical applications, each with its own local database. The application needs to lock the database row for write sometimes, so sharing the same database would be a performance hit (or is it?). If I want the two…
user217631
0
votes
2 answers

Setting up mysql on mac

I have successfully installed mysql on my mac, and now on the command-line I can type which mysql and the mac replies back the expected path. I would like to get started with the tutorial here. But according to that tutorial, I need to some…
John Berryman
  • 347
  • 3
  • 12
0
votes
1 answer

database mirroring and 10 Mbps

I was doing some tests with my two instance's of SQL Server 2008 R2 and 10 Mbps limited LAN. I setup synchronous database mirroring. Database log file is 25000 MB and 99% free before the test. I started to move some records and rebuild every index…
Geo
0
votes
1 answer

Database cache or file cache?

Imagine a websystem that's going to cache webpages; it's going to store about 10 million of 'm. The only thing I need to do is to return a webpage now and then from the cache, and update/delete webpages in the cache. The approximate size of the…
user59810
  • 109
  • 5
0
votes
3 answers

Mount Access Novell Netware 4.11 file(s) on Windows XP or above

We have old servers that serve application using FoxPro database and it's currently still operating till today. The operating system is using Netware 4.11 and the client is dumb terminal (boot from network interface card). 1. Is it possible to…
nawi2010
  • 3
  • 1
  • 2
0
votes
1 answer

Is the data in SQL Azure safe?

I am new to cloud computing. I don't know whether my question is correct. I have an application which has sensitive data. Suppose I had to move the database to the cloud. Is the data in the database safe from the vendors like Amazon and…
Jebli
  • 101
  • 2
0
votes
1 answer

Two MySQL Services on One Ubuntu Server Install

I am setting up a web staging environment and want to have a duplicate but separate MySQL service on the same machine. Development environments will connect to one service and staging environments will connect to another. This way when setting up a…
Kirk Ouimet
  • 559
  • 3
  • 11
  • 27
0
votes
3 answers

Map all SQL servers on a network with details

A colleague has been given a task of documenting SQL Servers for a client, that has about 200 servers (on physical and virtual hardware) with a total of about 1000 databases. What servers are on the network? What hardware are they running…
Kjensen
  • 1,039
  • 10
  • 28
  • 39
0
votes
1 answer

Limit on concurrent connections: Determined by webserver or database?

Does the webserver or is it the database that limits the number of concurrent connections?
hsym
  • 1,003
  • 3
  • 14
  • 26
0
votes
2 answers

Windows Server 2008 Web vs Standard

Please tell me what choice will be best between Windows Server 2008 R2 Web edition and Windows Server 2008 R2 Standard edition for NoSQLDatabase/BackendComputing scaling farm? I am pretty sure that there are can be 30-100 servers in net. What…
Edward83
  • 123
  • 1
  • 5
0
votes
1 answer

what server role is more demanding?

There's about 125 simultaneous users connecting by a mapped drive to server A hosting an application that each user is running. This application on server A is getting its data from an Oracle server on server B. The database is about 5GB and there's…
Jeff
  • 277
  • 3
  • 14
0
votes
1 answer

prevent unique constraint violations in clustered architecture

im working with four app servers and two database instances (3DNS and BigIP determine what app server a user is directed to based on usage etc). Two app servers per database node. The database instances stay synchronized using replication. However,…
cdugga
  • 105
  • 1
  • 5
0
votes
2 answers

mysql server does not start!

I had installed MySQL server 5.1.1 on my PC (windows 7 ultimate 32bit, CPU Dual core 2.60 MHz, 2.00 GB RAM) and it was up and running well, until last Wednesday I was forced to uninstall it, and now when I reinstall it,in the last level of creating…
Ehphan
  • 111
  • 2
  • 8
0
votes
2 answers

repair database

Possible Duplicate: repair suspect database my sql server 2008 told me that you database is suspect and I can't see my tables or my data what should I do ?
salamonti
  • 131
  • 3
1 2 3
…
99 100