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

SBSMonitoring.mdf reached limit

I have SBS 08 Standart. I have some Error in my Event Viewer with MSSQL$SBSMONITORING Event id 1105, 1827: Could not allocate space for object 'dbo.EventLog'.'PK_EventLog' in database 'SBSMonitoring' because the 'PRIMARY' filegroup is full.…
Bastien974
  • 1,896
  • 12
  • 44
  • 62
0
votes
3 answers

Database hardware advice

As a lone developer in my company I'm missing someone to bounce ideas off with. I've been given the task of gathering some hardware requirements for our server so we can make some internal websites public facing. Current hardware is SRV1 - Stats…
Alan Hollis
  • 181
  • 9
0
votes
2 answers

SQL Server: Restore database, data copy-redo-undo, clarification?

I have tried to understad how database restore works in SQL Server. I have read from BOL about different phases within the restore operation but did not understand much. Can you please clarify what these different phases do?
user55656
0
votes
1 answer

How to change schedule of backup jobs using SQL Management Studio

I have an SQL Server 2005 on our lab network, I installed MS SQL Management studio on separate computer to connect to the SQL Server to schedule a backup job of a few database. It worked fine for the backup jobs as scheduled, my question is how am I…
Bonifacio Acebedo
  • 1
  • 1
  • 1
0
votes
1 answer

Rebuilding a MySQL database from 160 retreived files with no name

I had a server crash and it took with it the hard drive. I put the hard drive in a USB enclosure, but the main partition would not mount because the partition was corrupted. I was able to see the USB hard drive, just not mount it. Using the "dd"…
Daniel
  • 31
  • 3
0
votes
4 answers

How to create empty database from existing one (Mysql)

I have a mysql db with many tables. I'm starting a new farm which should contain empty versions of the same database tables. How can I efficiently create empty database based on existing one?
Niro
  • 1,401
  • 4
  • 20
  • 36
0
votes
1 answer

Remote access to Microsoft Dynamics NAV (C/Side) with native non-SQL database

I am facing a company that have a fairly recent Microsoft Dynamics NAV (C/Side) setup that comes with a non-SQL storage system called the native database server. I would need to be remotely connect to this database, and perform what would equate to…
Joannes Vermorel
  • 493
  • 2
  • 5
  • 13
0
votes
4 answers

2 dedicated servers, one for the database server, and the other for webserver?

i wanted to buy 2 dedicated servers, and have one for holding the mysql database and the other one for running the web application, im not sure if thats a good idea. p.s. in terms of accessing data i was going to do database replication, having the…
Solomon Saleh
  • 193
  • 2
  • 9
0
votes
2 answers

Migrate DHCP from Cisco to Windows 2008

Is is possible to seamlessly migrate from DHCP on Cisco routers to a Windows server? All my searches give me tips on migrating from 2003 to 2008 DHCP but nothing on Cisco to Windows.
PHLiGHT
  • 1,041
  • 11
  • 25
0
votes
3 answers

How do you connect to BusinessObjects?

I have the rights to log into a BOXI server and build queries and reports, but can only export 100,000 rows at a time. I have tools on my desktop that can connect to databases via things like ODBC. Is there a way to use ODBC or some other connection…
Joe
0
votes
2 answers

Finding the bottleneck

I've just begun running some tests on our application system using JMeter. We are currently running a three-server setup. Requests go to a load balancer, which sends it to one of two apache servers (Ubuntu). Each of those servers has a link to a…
Dexter
  • 117
  • 1
  • 6
0
votes
1 answer

What must be done in order to configure IPSec for a domain?

A database server on the network is configured to require IP Security for all connections. I want to ensure that the rest of the machines in the domain can communicate with the server securely. What needs to be done to configure IPSec for the…
rlopez6570
  • 89
  • 1
  • 5
0
votes
2 answers

How to load another PHP's phpmyadmin to current PHP

In my application there are two PHP are available. 1) PHP 5.1.6 2) PHP 5.2.6 Currently I am using PHP 5.2.6 version in my application. Also I'm using PHP 5.2.6 database ( phpmyadmin ). Here my question is I want to use another PHP's database (…
user52534
  • 147
  • 1
  • 3
0
votes
1 answer

Can I predict to have query performance problems against a two column xref table with 25 million records?

I'm prototyping a design. In the design, I am considering creating a thin xref table (two integer fields) that would contain approximately 25 million records. Is this a crazy idea or would I still expect decent performance? By decent performance,…
Jordan Parmer
  • 137
  • 1
  • 7
0
votes
2 answers

Benchmark different kind of SQL database :What's the best test to do?

I have an application that i can configure to get data from different kind of SQL database server, for example Postgres, MSSQL, MySQL, Firebird ... I must install this application and the database server on windows enviroment, before choice the…
aleroot
  • 3,180
  • 6
  • 29
  • 37
1 2 3
…
99 100