Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
3
votes
2 answers

Why is my database not available?

I have one database on my server that constantly becomes unavailable. To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open failed: Could not open file C:...\MyDatabase.mdf…
Michael Itzoe
  • 215
  • 2
  • 5
  • 9
3
votes
3 answers

Access to SQL Server when administrator account deleted

An interesting situation here. We have a database server, used for testing only, where someone went in and deleted the administrator login. Since this is a test server the was no other admin level login on the server. Is there a way to get access to…
Shiraz Bhaiji
  • 2,229
  • 9
  • 34
  • 47
3
votes
2 answers

What are some reasons why a MySQL index would be 12X the size of the table?

So we have a table that has two indexes one on the primary key and one other index on another column on the table. The index size is currently 12X larger than the table itself. What are some reasons why this would happen? We've optimized the table…
Jon
  • 151
  • 4
3
votes
1 answer

Why is SQL Server automatically creating an explicit user mapping for my local Administrator account in every new database I create?

If I login to a particular instance of SQL Server 2008 using a Windows domain user who is in the sysadmin role and I create a brand new database via SQL Management Studio, a user in the newly create database is automatically mapped explicitly for my…
Rob Sobers
  • 333
  • 1
  • 4
  • 13
3
votes
2 answers

Restarting a database in a database instance without restarting entire database instance

I have a database server running several instances of database. I am having issues while accessing a particular database and want to restart the same but without restarting the entire db server as it will effect other databases in the instance or…
Viky
  • 648
  • 2
  • 7
  • 11
3
votes
2 answers

10 Million records = wiped MySQL DB?

So I was trying to load some test data and it appears to have killed my entire database. This is one case where it's great to have backups! They were all plain insert queries, probably about a 900 MB file. What could have gone wrong? When I woke up…
Josh K
  • 454
  • 1
  • 6
  • 18
2
votes
8 answers

What's a good free MySQL admin tool?

I'm looking at phpMyAdmin to manage users and create the database in the first place. Is it the best thing to go for, or are there other packages that are not web based that might be faster or better? I come from Postgres where pgAdmin III did…
Thomas Browne
  • 93
  • 1
  • 2
  • 14
2
votes
10 answers

Things every DBA for DB2 on Unix, Linux should know

What are the most useful resources for a DB2 DBA working on Unix or Linux? Books Web sites Tools etc.
Kevin Beck
  • 101
  • 1
  • 4
2
votes
1 answer

Postgresql: missing data after crash

I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8 It looks like all my postgresql databases were reverted to the state they were in 3 months ago. Columns that I added…
EoghanM
  • 560
  • 2
  • 7
  • 15
2
votes
2 answers

Scheduled copy of production database into test database

My question is similar to this one. I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and copy/clone one database. I Know I could schedule a…
Jonathan
  • 121
  • 1
  • 1
  • 4
2
votes
1 answer

Confused about horizontal scalling

Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, how do I distribute the database? Do I create one…
Benjamin Smith Max
  • 901
  • 6
  • 4
2
votes
6 answers

mySQL DBA Software

Are the free mySQL GUI tools adequate for administering a mySQL db running 'vendor' supplied applications? Are there other tools you would recommend that make your life easier?
Sam
  • 2,020
  • 1
  • 16
  • 22
2
votes
0 answers

SQL Azure Automated Backups doesn't work

I configured automated export of my SQL azure db, but backups are not created. Also, I'am resieved this mail. Automated SQL Export failed for [servername]:[dbname] at 25.09.2013 23:06:45. The temporary database copy was made, but this copy could …
IGusev
  • 21
  • 3
2
votes
2 answers

What tool generated this report of MySQL server performance?

I found this report on the performance of a MySQL server. I would like to be able to generate this report for my own server, but I don't know what tool they used. Does anybody recognise this report? What tool generates it? How can I get that tool…
Jim DeLaHunt
  • 135
  • 8
2
votes
3 answers

How do you clone an oracle instance?

How do you clone an oracle instance? Basically, I want to end up copying it from d:\oracle\oldname to d:\oracle\newname. I'm working with Oracle 10.2.
BIBD
  • 1,866
  • 10
  • 30
  • 44
1 2 3
…
19 20