Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-administration]

296 questions
0
votes
1 answer

What are the dangers/consequences of reducing the SharePoint_Config_log database?

I have used DBCC ShrinkFile on a SharePoint_Config_log database and I'm wondering what the consequences of this action may be? The log file was growing upwards to >11 GB for an 8GB database and space needed to be freed up. What are some of the…
Eric
  • 115
  • 5
0
votes
1 answer

On MySQL 5.1 for Windows, why can't I assign DBA role to the "root" user?

On MySQL 5.1 for Windows, why can't I assign DBA role to "root" user? The MySQL Workbench allows me to add all the other roles except for DBA. Also, when I "alter schema" on any table, while logged in as root, I dont see all the tabs that show…
djangofan
  • 4,182
  • 10
  • 46
  • 59
0
votes
2 answers

What Could Be Causing MySQL To Crash On A Read Query?

So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs. I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said something online the lines of "panic, reverting…
darkAsPitch
  • 1,931
  • 4
  • 25
  • 42
0
votes
1 answer

SQL 2008. How to let user to create/alter sprocs in only one particular schema?

I have a user which can read and write but now he needs to be able to create/alter a sproc but giving him ddl_admin will make it too unsecure. I dont trust him that much. What can I do about it? Can I somehow give him rights to alter a sproc in only…
Boppity Bop
  • 752
  • 3
  • 11
  • 34
0
votes
1 answer

Easiest way to export functions from a MySQL DB

I am migrating a bunch of changes from our dev database, consisting of some extra tables, the data from a subset of these tables, and some new functions. Using phpmyadmin I have exported the structure of the tables as an SQL file, and the data of…
James Green
  • 895
  • 1
  • 9
  • 23
0
votes
1 answer

Can MySQL use roles without MySQL Wokbench?

I have only found documentation about roles in MySQL through the use of Workbench, is there an alternative way to set them?
andandandand
  • 111
  • 4
0
votes
3 answers

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the database on server A and robocopy the A.bak over to a…
sc_ray
  • 107
  • 1
  • 6
0
votes
1 answer

How to copy marked lines in a Textpad...?

I had exported the table structure of my live Database.And open it with help of Textpad.It is very huge file and i want to copy a particular lines from the textpad.I mean,i want to copy marked lines only from the Textpad.Otherwise delete all other…
Jayakrishnan T
  • 298
  • 2
  • 8
  • 22
0
votes
1 answer

Error 2003 is Occurring when connecting MYSql through SQL yog tool

i couldn't able to login to my mysql database through SQLyog tool.The screen shot of the error is shown below and i can login the database through SSH Secure Shell.
Jayakrishnan T
  • 298
  • 2
  • 8
  • 22
0
votes
2 answers

Setting up mysql on mac

I have successfully installed mysql on my mac, and now on the command-line I can type which mysql and the mac replies back the expected path. I would like to get started with the tutorial here. But according to that tutorial, I need to some…
John Berryman
  • 347
  • 3
  • 12
0
votes
1 answer

Import remote postgresql database via ssh?

I have two machines: Remote, Ubuntu server, example.com, database: staging (owner user2, pass2), passwordless login for user1 (sudoer) via ssh Local, Ubuntu, localhost, database: local (owner user3, pass3) The question is: How to import data and…
takeshin
  • 1,471
  • 3
  • 21
  • 28
0
votes
1 answer

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a column to all those tables. Is there a way to do…
Continuation
  • 3,080
  • 5
  • 30
  • 38
0
votes
1 answer

SQL Database Admin or Developer?

Can someone explain the main difference between each? Which one do you consider more difficult? Which one is it easier to find and maintain a job? Im trying to start the first stepping stone of doing my certifications and learning more about MS-SQL…
user57862
0
votes
1 answer

SharePoint admin configuration inaccessible

I successfully moved three out of four SharePoint Service databases from one database server to another, except for the admin content database. Now I am unable to access the Admin Configuration on the old or new server, but the main SharePoint site…
marcwenger
  • 235
  • 1
  • 6
  • 21
0
votes
1 answer

Automatically drop FK's to re-create a table and then automatically put the FK's back

I have a number of incidents where SSMS tells me table recreation is required, even for something simple like making a column nullable. If this table is referenced by FK's, I would ideally like to find a way of temporarily removing those FK's from…
ProfK
  • 493
  • 5
  • 9
  • 28
1 2 3
…
19 20