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

How to back up a MSSQL Database

I have a MSSQL databse hosted on a windows server, What do I need to download a back up to my pc? I am familiar with backing up MSSQL databases, I believe I need to download a Microsoft database management program is this correct?
user40709
  • 151
  • 4
0
votes
2 answers

How I can upload an oracle ddl file of 15M

I have a file of 15 mb and i need run the sql of that file in oracle, but when I try load the file, I have a error: The file exceeds the maxim limit When I can change that limit or how I can run that sql file?
diegueus9
  • 117
  • 5
0
votes
2 answers

Problem in creating UDP sockets

Our production server is running PostgreSQL v8.2.3 on Red Hat Enterprise Linux Server release 5 (Tikanga). For some reason, statistics collector in PostgreSQL is not working. Even posted this question in PostgreSQL mailing list here: Statistics…
Gnanam
  • 1,459
  • 13
  • 26
  • 32
0
votes
1 answer

MySQL problem: "Incorrect key file for table ..."

I'm trying to migrate a mysql server to new hardware. The old server runs mysql 4.1.12 on RHEL 4; the new server is mysql 5.1.41 on Ubuntu 10.04. I've been having some strange issues trying to migrate one of the databases. I tried using…
Chris
0
votes
3 answers

Is it bad to design database that allow user to update PK?

I'm designing database which some tables have modifiable PK, I want to know, is design like this good or bad? Is it make programmer hard to code?
Ekkapop
  • 113
  • 1
  • 4
0
votes
3 answers

sp_msforeachdb does not list all databases on a SQL Server instance

I'm using sp_msforeachdb to list all databases on my server. I know it is unsupported, but I wonder why it does not list all the databases I have installed. This is how I run it: set run="C:\Program Files\Microsoft SQL…
Jeroen Wiert Pluimers
  • 290
  • 6
  • 14
0
votes
1 answer

Does Sql Server Database Mail use threads while sending mail?

We are using Sql Server 2008 Database Mails to send emails to our website visitors. I don't know whether Sql Server sends mail one by one by picking up from the queue or it will use threads to send emails in simultaneous fashion. If database mail…
kiran
0
votes
1 answer

Generation of backup put my website down - is there an easy solution?

On my database server there is a cronjob that backups all the databases in a way that makes it easy to restore them. It is something like this: 0 5 * * * /usr/local/bin/backup.php The problem is that the website (using that db server) is very slow…
Daniele
  • 661
  • 1
  • 7
  • 10
0
votes
1 answer

How to handle oracle installations with same SID on same subnet?

I have two Oracle RAC clusters on the same subnet. For this discussion, let's assume one is a QA cluster and one is a DEV cluster. They are both running on RedHat Enterprise Linux 5, 64-bit. They are configured identically, so they both have an…
David
  • 103
  • 3
0
votes
2 answers

What is a good django admin-like tool for postgres?

I am looking for a tool that will give a few people the ability to muck around in our database. Currently I write custom SQL queries every time we need to do something we don't have tools for. I don't want to write more tools because more often…
cs
0
votes
1 answer

Connect to and reindex Postgres database with system table errors

I've got a Postgres database that crashed (as well as the disk) and suffered some data errors (per After DB disk failure, now "cache lookup failed for index"). The initial problem seems to be the system tables, as the answer in that question…
bennylope
  • 103
  • 1
  • 6
0
votes
1 answer

After DB disk failure, now "cache lookup failed for index"

After resolving some problems with the network drive on which our Postgres database was hosted, we encountered this error: OperationalError: FATAL: cache lookup failed for index 2662 That particular error was from a Python command line, but other…
bennylope
  • 103
  • 1
  • 6
0
votes
2 answers

How to encrypt data at rest

How can you encrypt data at rest on Sql Server Web Edition? TDE is apparently not an option, but I don't know what else is available. Any recommendations?
Brandi
  • 177
  • 1
  • 6
0
votes
2 answers

Migration from Oracle 10gR2 to Oracle XE

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc. I want to migrate to Oracle XE. Can this edition serve as the primary database for a server? Also, i am unclear, about is…
M.N
  • 337
  • 3
  • 7
  • 15
0
votes
3 answers

Exporting a MS SQL express database

I'm attempting to take a current website that uses MS SQL Express 2005 and create a redundant site on another domain. I've only ever worked with MySQL, and can't seem to find a way to export this data. I think I read somewhere that I need to…
kylex
  • 1,421
  • 5
  • 14
  • 18
1 2 3
…
99 100