The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

6
votes
0answers
85 views

How to reload a linked server?

I am using Microsoft SQL Server 2014 - Enterprise Edition, a problem occurs with the linked servers where it is necessary to restart the server or to stop the MSSQLSERVER services. When the server is ...
3
votes
0answers
82 views

How can I generated a list of all DB2 Objects including Last Modified Date of object on AS400?

I am going through an audit, of an AS400 application. AS400 has a DB2 database, and I need to generate a list of all DB2 Objects/Tables including their last modified date. Can anyone help me? Thanks ...
3
votes
0answers
50 views

PostgreSQL Streaming Replication Tools - Windows

Is there any clusterware available for PostgreSQL clusters running on Windows OS? I'm specifically interested in automatic failover and STONITH functionality. I've done a fairly extensive Google ...
3
votes
0answers
68 views

Need a way to prevent log shipping from kicking users out

We have SQL Server 2012. A service we use requires us to use log shipping, however we are tired of having users being kicked offline every 15 minutes. Are there any creative ways to get around this ...
3
votes
0answers
14k views

Importing a different character set export dump into another DB instance

I am trying to import a given dump file using oracle imp utility. However; I am facing the following issues. C:\Users\AD>imp DB_USER/*****@dev1 file=C:\test\db42312.dmp log=C:\test\import2.log ...
3
votes
0answers
1k views

Once more about SQL Server virtual accounts

Let me reboot my question on SQL Server virtual accounts permissions The (same) MSDN article on the same version 2012 of SQL Server "Configure Windows Service Accounts and Permissions" states: ...
3
votes
0answers
528 views

How to properly configure pgBouncer transaction level pooling?

What is a good way to determine the number of available transaction connections when using pgBouncer to pool database connections? Also, how should I determine the number of max_connections and ...
3
votes
0answers
643 views

SQL Developer Data Modeller and Data Dictionary question

I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please? I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
2
votes
0answers
28 views

Create File,secondary FileGroup then move a table and restore database with 'Primary'

i created secondary FileGroup , linked a File then moved a table there and restore database with 'Primary' however the table name still there and when I use the select statement I got an error that it ...
2
votes
0answers
39 views

Database Corruption - object in sys.parameters does not have a matching row in sys.objects

I'm using SQL Server 2008 R2 and I have a strange db corruption. I ran dbcc check db and the output is: Attribute (object_id=1096186) of row (object_id=1096186,parameter_id=1) in sys.parameters ...
2
votes
0answers
47 views

CPU utilization reached 100% after changing OS time on SQL Server with Mirroring configured for a database

We have configured mirroring on SQL database server. Suddenly principal database server reached 100% CPU, windows log events shows following 2 logs This event is generated when the system time ...
2
votes
0answers
195 views

Exclude a User From an Audit

I need to set up a SQL Server audit to capture all database activity for all logins except one - the login our application runs under. In this case the login I want to exclude is CPSDOM\cpointedb. In ...
2
votes
0answers
577 views

Recover innodb database from ibdata1 and *.frm files only

I have a problem on my server. I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started. I checked all mysql data, ...
2
votes
0answers
122 views

Should I use SQL Azure to store product descriptions and links to images in Azure Blob

For an html/Css/JQuery public Azure website to be coded using Zurb Foundation html5 responsive framework, I'd like to use SQL Azure (web edition) to store product descriptions and links to images that ...
2
votes
0answers
513 views

IBM DB2 Command line Window - Administrator disappears on windows server 2008 r2?

I have installed IBM DB2 version 10 on windows server 2008 r2 machine. However i am unable to open it's command line window. For example: Whenever i try to open Command Windows - Administrator it ...
2
votes
0answers
173 views

How to give permissions to 90+ SQL Servers without tweaking in each of them?

There are over 90+ MS SQL Servers (SQL Server 2005, 2008 and 2012). All in the same Windows domain (but physically all over the world). How to give a domain user (administrative, or other) ...
2
votes
0answers
115 views

How to calculate the ratio insert/select against a table to manage the index in Sybase ASE?

To create/manage indexes of a table, it is important to know the ratio insert/select or modification/reporting. For instance, if there are more INSERTS than SELECT against a table, we should try to ...
2
votes
0answers
466 views

SQL Server SSIS issue retrieve data when i enter into login of server side?

can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side here is the error message TITLE: Microsoft SQL Server Management Studio ...
1
vote
0answers
20 views

How to bucketize using Query optimal bucketization algorithm

I am trying to implement query optimal bucketization algorithm (QOB). The input of the algorithm is D=(V,F) where V is the value of the attribute and F is the frequency of occurrence. For EXAMPLE D ...
1
vote
0answers
27 views

IBM Bluemix SQL Database service data store management

I'm working on IBM Bluemix SQL Database service with premium plan. According to our application the sql service can have many schemas. Is there any way to seperate data storage of each schema to ...
1
vote
0answers
25 views

After disabling replication, should I disable binary logging?

I have a master-slave setup currently but am going to remove the replication DB server. The DBs are running on MySQL 5.6. I have a couple of questions about removing the replication: 1) I have read ...
1
vote
0answers
63 views

Prdouction Database went into restoring mode

Yesterday one of my production database went into restoring mode,but fortunately i recovered it using below query USE MASTER EXEC SP_CONFIGURE 'Allow updates',1 RECONFIGURE WITH OVERRIDE GO EXEC ...
1
vote
0answers
54 views

SQLPlus TNS:protocol adapter error

i have two Oracle 12c instances. currently both are shutdown. when I try to connect with sqlplus / as sysdba it says tns protocol adapter error contents of tnsnames.ora are DB12102 = (DESCRIPTION = ...
1
vote
0answers
60 views

Sql Server Reporting Services will not connect to sql server 2008r2 using SQL server Connection

I have set up a new SQL Server 2014 default instance. In my Sql Server 2014 Configuration manager I see my 32 and 64 bit SQL Native Client 11.0 configurations and all protocols, pipes, tcp/ip,shared ...
1
vote
0answers
52 views

Error: 17806, Severity: 20, State: 14

I have frequent access error log like below: Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated ...
1
vote
0answers
200 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

1. I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. 2. I have a MySQL 5.6 server (community edition ) on another Linux server which is ...
1
vote
0answers
341 views

Linked Server vs. Ad Hoc (OpenRowset / OpenDatasource) Distributed Queries

I have an application which needs to grab data from different clients' databases that reside at the client's location. So alongside their normal details such as company name, address etc, I also store ...
1
vote
0answers
34 views

Managing logs generated by user

I am developing a web app for my client and there is a section which displays the changes made in the application by any of the user. This section is known as log.It basically stores and displays the ...
1
vote
0answers
89 views

Data compression within Internal Tables in SQL server 2008R2

We are doing downgrade from enterprise to standard for couple of servers which are not using any enterprise features: For one of our TFS(Team foundation server) database TFS_resx, when we ran ...
1
vote
0answers
114 views

Export entire Oracle schema to ASCII and import into DB2

I'm looking for a solution to export a number of schemas from Oracle to ASCII or other flat file format. The data then has to be read by DB2 import. Does anyone know the what oracle export commands ...
1
vote
0answers
29 views

DB2 Change Journal Receiver Size

We are running DB2 on our iSeries, and there is a journal + journal receiver created. The current size of the journal receiver is 200MB (found using the DSPJRNRCVA command). Is there a way to change ...
1
vote
0answers
368 views

Reducing the size of a PostgreSQL Database, utilizing a process other than full VACUUM

We have a Postgres 8.4 installation which hosts both our Defect tracking and Code management (Surround) systems. We are looking at converting and migrating Surround to MSSQL on another server. Our ...
1
vote
0answers
114 views

Severity 20 Error upon disconnecting Dedicated Administrator Connection

Starting working with Dedicated Administrator Connections on SQL Server 2008 R2 servers. All is working fine (once port 1434 was opened), but am getting severity 20 errors when I disconnect the admin ...
1
vote
0answers
45 views

Best ratio for files and file groups for a highly partitioned table

I have a number of tables with exactly 1000 partitions. Each table can be up to 200G with 100M rows and cannot be compressed. Data in partitions distributed quite equally. The SQL Server has 8 ...
1
vote
0answers
210 views

File group space problem

I'm having some problems with my database usage space. I have a database with autogrowth off and limited size to 150GB. When users try to import files, large databases or other massive transaction ...
1
vote
0answers
24 views

CHKDB is marked RESTORING

I am seeing this in my Microsoft SQL Server 2008 R2 (SP1) database log: The database 'CHKDB_dbname' is marked RESTORING and is in a state that does not allow recovery to be run. This occurred ...
1
vote
0answers
109 views

Where to put standby control file in Physical standby database?

I am creating a physical standby database for which I am creating a standby control file using command = ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/dbs/stbycf.ctl'; but It creates only one ...
1
vote
0answers
71 views

mirroring on sql server 2012 on different windows server 2012

I have 2 servers *.203 and *.205 I have sql server 2012 on each of them I tried to make mirroring between them every thing goes successfuly but when I tried to start mirroring it gives me ...
1
vote
0answers
40 views

Restore postgresql database from remote sql file

I would like to know if it's possible to restore a database from a remote sql file. The problem: - Working with PostgreSQL 9.2.4 - I have an small remote server with 10GB left in storage - I have a ...
1
vote
0answers
5k views

Truncating Table Partitions Containing Data and Global Indexes

I have to truncate a partition (392,000 records) of a table with 20.000.000 records. At the moment, I'm making a truncate table and rebuilding indexes. But the table has 37 indexes and it takes 20 ...
1
vote
0answers
128 views

Best practices for ranking records in flexible way

Suppose we have 10000 records of any product. User search on our website with his given criteria. so we output search results based on given criteria. Now Admin want to rank products in search. so ...
1
vote
0answers
1k views

Analyzing MySQL crash due to corrupt InnoDB page. Failed page checksum

Lately we have been pestered by infrequent sporadic database crashes on one of our MySQL instances. Each time it is due to a failed page checksum. It happens on a specific database but spans multiple ...
1
vote
0answers
152 views

Can maintenance plans be used in SQL Server multiserver (Master-Target servers) administration?

Since I failed to configure SQL Server 2012 Multiserver (Master and Target Servers) administration, I am eager to understand whether it (setting Master and Target servers) would permit to send from ...
1
vote
0answers
2k views

How to debug problems with SQL Server multiserver (Master and Target server) administration?

I've tried to set Mater and Target Servers on various cobinations of SQL Servers 2012 R2 on Window Server 2008 R2 and Windows 7 machines but always getting one or 2 of the following errors during ...
1
vote
0answers
36 views

sp_spaceused and replication question

I have been replicating data from a table to 2 different locations and was just looking at sp_spaceused to see the size of the tables. I have noticed that the replicated tables are smaller than the ...
1
vote
0answers
330 views

Database Timeout Error from VB Application

Recently we are receiving so many database timeout error from different servers we are using vb application -- which will use ODBC connection to connect database - here no problem when we run the ...
1
vote
0answers
261 views

Database instance keeps restarting

From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
0
votes
0answers
14 views

search pgadmin for column

I'm a front end dev and this is my first time doing serious database work. I have json sent to the client that looks like this: prop[0].event.history = 'foo'; //can also be 'bar' I wanted to ...
0
votes
0answers
6 views

What are the advantages of Packet Inspection and SHOW FULL PROCESSLIST over PERFORMANCE_SCHEMA?

We have several MySQL Servers (v 5.1) scattered across different geo locations. We are considering upgrading to the latest MySQL version as we heard a lot of good things about PERFORMANCE_SCHEMA ...
0
votes
0answers
21 views

Phpmyadmin not displaying table data

I have a table named "log", which basically stores error log for my php application. My application has database running on rds, and recently i had to delete logs from this table, so i downloaded a ...