Questions tagged [database-administration]
296 questions
2
votes
1 answer
Opening an oracle database crashes the service
I am experiencing a weird issue with Oracle where the service started fine after a crash. The database mount went fine as well. However, when I issue alter database open; command, the database does not open, gives a generic cannot connect to the…
tundal45
2
votes
2 answers
SQL Server 2005: Rename DB Server Instance Name?
Can somebody tell me how to rename the DB server instance name and a DB name
in SQL Server 2005?
Right Now I Have
SERVER/OLDNAME
-- oldnameDB
I want to change the server instance and also change the db name.
I have tried:
EXEC sp_renamedb…
Peter
- 163
- 5
2
votes
1 answer
MSSQL Replace Database in Live Web App
I have a web app that is currently live. I had the need to make major modifications to the database and now I need to replace the current one.
My dev SQL instance is not the live one. I usually just make a backup of the new DB, blow the old one…
Jason
- 279
- 2
- 10
2
votes
5 answers
How can I synchronize MS SQL Server databases?
How can I synchronize MS SQL Server databases? Is there any tool, preferably open source?
Rajesh
- 137
- 1
- 1
- 4
1
vote
2 answers
How to change the default instance of SQL Server?
we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance.
Nowadays we barely use the SQL2000 instance, but this is the default. We would like the SQL2005 to be the default instance…
empz
- 247
- 1
- 6
- 15
1
vote
2 answers
Can't change the data-directory for MariaDB Centos7.6
I have a fresh install of Centos 7.6 which includes standard partition scheme for Centos 7.6 install. Which includes a "/" directory partition of 50GB. I would like to move the default nysql (mariadb) data directory so I don't fill up the root…
I'm Root James
- 212
- 3
- 13
1
vote
2 answers
How to restore just ONE mysql database from a collective backup
I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file.
How can I tell mysql to import ONE of the databases contained in the dump file?
-M
Thanks for the answer guys. Much appreciated...
I…
Mike B
- 11,871
- 42
- 107
- 168
1
vote
2 answers
Unable to back up SQL Server databases using a maintenance plan
I am trying to create a maintenance plan that will run automatically and back up my SQL Server 2005 databases automatically. I create a new maintenance plan and add a "Back Up Database Task", select all databases, and choose a path to back up to. …
Stephen Jennings
- 1,393
- 3
- 23
- 30
1
vote
1 answer
Should SQL Server min and max memory settings be fixed to the same value
Hello,
If the server has the resources to dedicate to the SQL server should you keep the min and max server memory settings fixed at the same value?
Will setting the values the same produce any performance benefit by keeping the memory available…
user142253
- 123
- 3
1
vote
0 answers
Registering oracle 10g db with 12c grid
Hi I have oracle grid infrastructure 12c installed for stand alone server and I'm trying to register oracle database 10g with CRS, but I suspect there was syntax change because srvctl fails when calling srvctl in 10g home outputing usage hint.
full…
Daniel Staněk
- 11
- 1
1
vote
3 answers
Proper Way to Grant Permissions in PostgreSQL
I am new to PostgreSQL and am having a bit of trouble finding any information on how to grant a user permissions on the database that they own. I have read a few sources that says the owner has all permissions, but it doesn't seem to work for me. I…
Topher Fangio
- 279
- 3
- 13
1
vote
1 answer
Can oracle handle SERVER = POOLED (DRCP) and SERVER = DEDICATED clients simultaneously?
I run a PHP application that uses an Oracle 11g instance as it's backend. We currently connect with DEDICATED as our type but we're having trouble scaling.
As such, I suggested to the DBA we implement DRCP connection pooling as this seems to be…
user126715
- 163
- 1
- 1
- 4
1
vote
2 answers
cassandra nodetool drain running for days
We are having performance problems with our cluster regarding to timeouts when repairs are running or massive deletes. One of the advice I received was update our casssandra version from 2.0.17 to 2.2. I am draining one of the nodes to start the…
ftrujillo
- 149
- 9
1
vote
0 answers
MariaDB query cache not being used with prepared statements
We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do get cached.
I have read MySQL query cache is…
Márcio Martins
- 141
- 1
- 7
1
vote
2 answers
How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it
I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close 90% of the drive.
Running the following query I…
gaganHR
- 121
- 1
- 2