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
4
votes
5 answers

How can I remove unallocated space from a SQL Server database?

I have a database that was recently shrunk and when I run sp_spaceused I see that it has 500MB of unallocated space. I'm trying to keep this database to a certain size (do to MSDE size restrictions for my desktop users) and I'm not sure if the…
Shane
  • 1,869
  • 4
  • 20
  • 34
4
votes
5 answers

mysqldump for sql server

I have used mysqldump on a mysql database lots of times and am familiar with how it works. Does anyone know if there is a similar tool that could be used on a sql server database. I know sql server can backup its database but I would like to get all…
Simon Foster
  • 2,622
  • 6
  • 38
  • 55
4
votes
2 answers

MySQL replication: Getting the master in sync with the slave again

I have two computers on the same network, in a master-slave replication setup. Simply to test failover, I inserted some data straight into the slave database. So now the slave database contains more information than the master database. Now I want…
Deniz Dogan
  • 143
  • 1
  • 3
4
votes
2 answers

How to handle one-way synchronization of two Oracle databases with no network connection?

Here's the situation: I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the data on database B to match that database A. Database…
ColinD
  • 143
  • 1
  • 5
4
votes
2 answers

Guaranteeing ACID properties for InnoDB databases

What steps must one take to ensure that an otherwise defaultly-configured InnoDB server is truly ACID compliant? The InnoDB configuration page mentions that the hardware itself must be configured to honor fsync calls, i.e. disable any write-back…
plinehan
  • 675
  • 1
  • 5
  • 6
4
votes
3 answers

Synchronize Active Directory to Database

We are in a situation where we would like to offer our customers to be able to manage their users themselves. It is around 300 customers with up to a total of 10.000 users. Besides creating, updating and removing users, they will very often read…
Tommy Jakobsen
  • 259
  • 5
  • 10
4
votes
5 answers

What statistics app should I use for my website?

I have my own server (with root access). I need statistics of users who visit my website etc etc... I have looked at an app called Webalyzer... Is this a good choice? I run apache2 on a Ubuntu 9 system... If you know of any good statistics apps for…
Anonymous12345
  • 1,022
  • 2
  • 13
  • 18
4
votes
1 answer

SQL Server 2008 Unique Problem for bring DB Online

This is my error I am facing TITLE: Microsoft.SqlServer.Smo Set offline failed for Database 'Go3D_Retailer ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. …
Nai
  • 743
  • 1
  • 6
  • 24
4
votes
3 answers

Which free RDBMS is best for small in-house development?

I am the sole sysadmin for a small firm of about 50 people, and I have been asked to develop an in-house application for tracking job completion and providing reports based on that data. I'm planning on building it as a web application. I have…
Nic
  • 13,425
  • 17
  • 61
  • 104
4
votes
7 answers

soft/fake raid in linux

original I don't have much experience with Linux, but this is a good oportunity to learn I'm mounting a simple database server and i would like to know if ubuntu server 9.10 (what do you guys recommend for a [begginer] server distribution ?) would…
arthurprs
  • 141
  • 4
4
votes
2 answers

SQL Default Instance Name

Can the default instance name be something other than (local) or (machinename)? For example, if my server is called Apple, and I install SQL Server 2008 and choose to create a default instance and name it Orange, will this work? Will I then be able…
Nick
  • 215
  • 5
  • 8
4
votes
5 answers

What are the consequences if I backup LIVE databases every 3-hours using mysqldump?

If I am not mistaken, when executing mysqldump, it will lock the tables, isn't it? Erm, never mind, my question is: What are the consequences if I backup LIVE databases hourly using mysqldump? I have lots of databases (around 15), but the ones that…
deadman
4
votes
4 answers

mysqldump --where with = operator doesn't get all rows

I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition. This table has 9 fields in it. One of them is a domain_id field. It is the best…
JonathanLIVE
  • 197
  • 2
  • 5
  • 10
4
votes
3 answers

Is an alternative there for Oracle Total Recall?

Oracle Total Recall is an option for Oracle Enterprise Edition (11g) that provides secure retention and access of historical data. From the white paper: Flashback Data Archive creates an internal history table for every tracked table. The…
TH.
  • 205
  • 1
  • 10
4
votes
2 answers

Influxdb is restarting constantly since my last reboot

Since my last reboot, I am seeing the following every 1-2 minutes: Aug 02 13:53:00 monitor systemd[1]: influxdb.service: start operation timed out. Terminating. Aug 02 13:53:00 monitor systemd[1]: influxdb.service: Failed with result 'timeout'. Aug…
SlyOne
  • 363
  • 2
  • 7
1 2 3
…
99 100