Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
0
votes
1 answer

MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS

I will be uploading a web application to amazon ec2 instance in the next couple of weeks. I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS. The only confusion i have is database (MySQL) related. As i am the…
ccot
  • 181
  • 2
  • 11
0
votes
1 answer

ASP.NET Application Connection String and SQL Server Security / Permissions

I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company and is not part of our internal network. I have a…
Chris Cannon
  • 103
  • 3
0
votes
1 answer

Scripts to automate maintenance on thousands of databases?

We have a web application that, for government-regulated security reasons, requires each client to have their own database. As a result, we have a few thousand small databases that all have the exact same schema (each database is between 10MB and…
Beep beep
  • 1,833
  • 2
  • 18
  • 33
0
votes
1 answer

How to set backup / database in order to maintain heavy write loads

I have a write heavy application. Approx 5lac+ inserts per day in a MySQL table. I have master <> master -> slave. Performance is not an issue here. I need your inputs with regards to management of the data. After a certain ammount of time I'd see…
my_sql
  • 1
0
votes
1 answer

How often would you run the Postgresql maintenance tasks

After reading the Postgresql documentation, we found that it's recommendable to run the Vacuum tasks daily: We recommend that active production databases be vacuumed frequently (at least nightly), in order to remove dead rows. Nonetheless, we're…
SDReyes
  • 653
  • 2
  • 8
  • 15
0
votes
2 answers

Curious about my database server setup

I'm a web developer by day but I haven't had as much server administration experience as I'd like. I'm working on some side projects which are hosted on a 512mb linode server. The main app that I'm working on is a rails app that really doesn't do…
Brandon Cordell
  • 103
  • 4
0
votes
1 answer

copy a MySQL table which has data in ibdata file

I have a database in MySQL with several tables. Some of the tables only have .frm files. Some have .frm .mdy .mdi I believe data for the .frm tables is in the ibdata file. There is a lot of data in all the tables and I can see it. How do I make a…
Beginner
  • 133
  • 1
  • 2
  • 8
0
votes
2 answers

Move SQL Server Databases to new installation

I am reinstalling Windows on a developer workstation, that runs SQL Server 2008R2 and contains a lot of SQL Server databases (~50). After the reinstall, I want the SQL Server up and running with the same databases as easy as possible. It is just a…
Kjensen
  • 1,039
  • 10
  • 28
  • 39
0
votes
1 answer

How was the MSSQL Server database erased in the production server (that is a different version? )

I'm asking for help understanding what happened in my situation or what and if I did something wrong. I have production server running on a Windows 2003 server with MSSQL Express 2005 with an app (production server). I was told to prepare a test…
Feiticeir0
  • 434
  • 3
  • 11
0
votes
1 answer

Backup SQL Server database to local machine

I'm connected to the remote database using SQL Server Management Studio 2008. I'm a little bit limited for space on my server, so I just want to do a backup to an external drive connected to my laptop. When I select the backup location (through…
109221793
  • 315
  • 1
  • 3
  • 13
0
votes
1 answer

Validate SQL Server partitions and filegroups

Information: I took over a SQL Server 2005 that the previous DBA had configured three filegroups to segregate the data onto unique LUNs: G: Data (Primary) F: Audit J: Index However, the developers are not certain that these Filegroups have been…
David Mathis
  • 898
  • 2
  • 9
  • 21
0
votes
1 answer

Managing multiple storage volumes in Microsoft SQL Server

I have a backup application backed by many databases (one per client) in Microsoft SQL Server, storing files in the database as BLOBs. We are looking to move this application to Amazon EC2, and want to have 3TB of disk available. The largest EBS…
crb
  • 7,998
  • 1
  • 38
  • 53
0
votes
3 answers

Finding an optimal balance of I/O, CPU, and RAM for MySQL

For a long time I’ve wanted to know how MySQL scales as you add more memory to the server.We looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, and lowering the price-to-performance ratio.Please…
Jayakrishnan T
  • 298
  • 2
  • 8
  • 22
0
votes
2 answers

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. I have heard that there is also problems using…
jrara
  • 209
  • 2
  • 6
  • 14
0
votes
1 answer

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity timeout" I seriously doubt that this is a server…
sarat
  • 213
  • 3
  • 11
1 2 3
…
19 20