Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

293 questions
4
votes
3 answers

MySQL maintenance - how to clear the buffer?

We have a server running our PHP/MySQL-based web application which is SLOW. My predecessor says: We used to do database maintenance, which used to clear the buffer, cached and unwanted variables. And I wonder what on earth he means with that…
Dougal
  • 43
  • 1
  • 1
  • 3
4
votes
4 answers

How to shape size of SQL server resorces (RAM, CPU, and others)

It is standard story, there is fight between developers and administrators. One denunciation that database design and queries are bad while others says It is lack of hardware and amount of data. So I am asking You is my IBM x3400 with 2 xenons…
adopilot
  • 1,501
  • 6
  • 25
  • 40
4
votes
3 answers

Shrink SQL Server data file, but not all at once?

I have a database file that's currently 150GB, but only 75GB is being used - it's because I moved all the indexes (the other 75GB) to a new data file. I'd like to reclaim at least part of the space from this data file, but when I attempt to shrink…
SqlRyan
  • 906
  • 5
  • 13
  • 22
4
votes
2 answers

Move a Database that is in restore mode

I have a database which is the recipient of a logshipping process. The database is in 'restoring'. Is it possible to move this database? EDIT Just to clarify what I meant by move. I mean to make a copy of the database and transfer it to another…
Nai
  • 743
  • 1
  • 6
  • 24
4
votes
2 answers

Script logon to a 'Cisco' VPN in windows

I would like to sync my development database with actual data from the production databases on a regular basis (say, weekly). I already have the scripts to do this, and the amount of data is not huge. The problem is that we access the client…
N Reed
  • 182
  • 3
  • 7
3
votes
4 answers

Using linked servers to query across database servers?

We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The databases vary in size, but average in the tens…
Jeff Meatball Yang
  • 233
  • 2
  • 7
3
votes
1 answer

Upgrading PostgreSQL on EC2 with minimum impact to existing configuration

I have PostgreSQL 9.2 installed on an EC2 instance, with yum install. I now need to upgrade to PostgreSQL 9.4. I've noticed that yum list lists 9.2, 9.3 and 9.4 as completely separate packages, so I can't just upgrade using yum upgrade…
Eugene Osovetsky
  • 171
  • 1
  • 7
3
votes
2 answers

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case of the database owner/administrator not having…
Alex R
  • 972
  • 3
  • 12
  • 26
3
votes
2 answers

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should suffice to dump the table: mysqldump -u root -p…
tony_perkis666
  • 243
  • 2
  • 12
3
votes
3 answers

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you let it sit all day. Even just a check gets hung at…
Tiffany Walker
  • 6,541
  • 13
  • 53
  • 77
3
votes
1 answer

Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This error may indicate data corruption or that the log…
Velu
  • 171
  • 1
  • 4
3
votes
4 answers

How many Database accounts

How many user accounts should be setup for a given application? Where should the separation be? Should it be one login per application? 1 Application per program? 1 for front end and backend? How do you set up your database accounts?
C. Ross
  • 2,995
  • 8
  • 32
  • 36
3
votes
2 answers

How do I connect to a SQL Server on an ISP using SQL Server Management Studio?

It's actually SQL Server Management Studio Express. Do I need the full version? How do I connect?
Robert Harvey
  • 156
  • 14
3
votes
2 answers

Online Schema Change Strategies for Large MySQL Tables

I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of conversation, let's say 2 million+ rows to which…
sinping
  • 2,055
  • 14
  • 12
3
votes
4 answers

Best practices for SQL Server audit trail

I'm facing a situation today where it would be very beneficial to me and my company if we knew who had logged into SQL and performed some deletions. We have a situation where at least 2 (sometimes 3) people login to SQL using SQL Server Management…
Ducain
  • 473
  • 2
  • 10
  • 20
1 2 3
…
19 20