Operating system produced by Microsoft. Windows is produced in various desktop and server versions.

learn more… | top users | synonyms

-8
votes
3answers
503 views

Wrong Last Modified Date of .ndf file on SQL Server [closed]

I have SQL Server Database and we have many tables. To improve performance, I have created different filegroups with files on different disks just for indexes. I have created new index today in a ...
0
votes
0answers
184 views

Create a high availability cluster configuration PostgreSQL for Windows

I want a server to be replicated, here is the scenario: When my primary server goes down or fail I want the secondary or the standby server to take over, I'm using Windows 7 for the primary server, ...
-1
votes
1answer
129 views

Restoring Oracle XE database

I had Oracle 10G XE installed on my Windows machine. The machine got corrupted and I will have to install Oracle again. I did not take a backup in the form of SQL queries. How can I use the old ...
5
votes
2answers
3k views

Cannot open table mysql/innodb_index_stats

After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well. The errors I ...
0
votes
1answer
123 views

Restoring old MySQL database settings

I know this question may be similar to some others posted but think it may be slightly different, so hopefully it's ok. Basically I just reinstalled Windows as I bought a new HD and I am in the ...
2
votes
1answer
1k views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details
0
votes
1answer
93 views

Windows Service Management Node Won't Start

I'm trying to set up a basic Cluster on my Win7 PC for testing. But I am stuck at the first hurdle. I have installed the Management Node as a Service: ...
7
votes
2answers
1k views

How to do incremental/differential backup every hour in Postgres 9.1?

Trying to do an hourly hot incremental backup of a single postgres server. I have the following setup in postgresql.conf: max_wal_senders=2 wal_level=archive archive_mode=on archive_command='copy ...
0
votes
0answers
170 views

MySQL multi master replication with bi-directional synchronization advice

I need a solution to replicate data between multiple MySQL masters running on different platforms (Windows XP, 7 and Ubuntu Linux). I have found a replication tool (SymmetricDS) which supports this ...
8
votes
1answer
690 views

On which machine should TCP Chimney Offload be disabled?

I am advising someone on how to disable TCP Chimney Offload, which is enabled by default by Windows Server 2003 SP2. We are working in an environment with multiple server machines, namely the ...
1
vote
2answers
428 views

Need to install Oracle Express 11g Release 2 on a Windows 7 64-bit laptop

I need the Oracle 11g Release 2 sample schemas (HR, OE, etc.) in order to do most of the available online tutorials. I was hoping to install Oracle Express Edition on my Windows 7 laptop to get ...
0
votes
0answers
269 views

Export (mysqldump) databases from MySQL version 4.0?

I need to export the schema and data from a MySQL version 4.0.16 DB. I was asked to migrate a database from MySQL version 4.0.16. The database was installed on a Windows XP machine, and I could not ...
0
votes
0answers
322 views

Oracle XE 11g on Windows 7 64bits

I have a problem with Oracle XE 11g on Windows 7 64. I know that a lot of people have the same problem but I did'nt find a solution for my case. In sqlnet.ora: with SQLNET.AUTHENTICATION_SERVICES = ...
0
votes
1answer
75 views

MySQL Cluster Setup for WAN on Windows

I would like to know whether replication or clustering for MySQL is it possible over a WAN environment? For example Site A and Site B are both at different remote place. Both have MySQL installed. ...
0
votes
4answers
711 views

How do I backup a database from MySQL 32-bit and restore it to MySQL 64-bit?

I'm currently using MySQL version 5.0.16, on my local computer (which runs a 32-bit OS), for easier access while developing my program. Now that I'm ready to deploy my program, I'd like to test the ...
12
votes
1answer
3k views

“Access is denied” when connecting SSMS to Integration Services

I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name: Connecting to Integration Services service on the ...
0
votes
0answers
290 views

PostgreSQL 9.2.4 (Windows 7) - Service won't start, “could not load pg_hba.conf”

I am trying to get Postgres 9.2.4 to run as a service on Windows 7. After installing postgres, the service was running fine. However, after setting postgres up as a server for another program, the ...
2
votes
1answer
844 views

How to restore IBM DB2 database from AIX to Windows?

I had made backup from remote IBM DB2 server in AIX using this command: ./db2 backup database DBEMP to /home/dbemp/backup Then I grab the backup file using FTP Client from my Windows. I run this ...
0
votes
0answers
89 views

Performance of large queries on low bandwidth connections

I've been running some measurements on bandwidth needs and the effects of latency on query performance against Postgres 8.3 (waiting for management to approve upgrade) on Windows. SELECTs of various ...
0
votes
0answers
98 views

mysqlnd: same mysql server and php version, can't connect from Windows

(This question is also in StackOverflow http://stackoverflow.com/questions/16575994/mysqlnd-same-mysql-server-and-php-version-cant-connect-from-windows) I'm migrating mysql functions to mysqli. As ...
2
votes
1answer
430 views

If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?

Some background first: The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset: Data access only through views and stored procs --> ...
0
votes
0answers
18 views

Authenticate Oracle Database with Active Directory Users [duplicate]

I'm trying to connect to Oracle Database 11gR2 with the users from Active Directory. I'm looking at some resources/guidance on how to go about doing this successfully. The link Map Oracle Roles to ...
1
vote
1answer
110 views

Restrict access for Windows administrator in PostgreSQL

Is there a way to protect PostgreSQL from user with Windows administrator rights? Like this question but for Postgres.
1
vote
1answer
358 views

Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?

Having a corrupted Mysql 5.5.31 (Windows) database, my question relates to the the top solution provided in How do you identify InnoDB table corruption? , more precisely to the following script that ...
2
votes
2answers
436 views

Changing PostgreSQL port using command line

My PostgreSQL default port is 5432, I want to change default port by using command line (in Windows 7). I saw this solution before: http://stackoverflow.com/questions/187438/want-to-change-pgsql-port ...
0
votes
2answers
433 views

Can I find out what version of MySQL from the data files?

I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
1
vote
1answer
121 views

Oracle Express intermittently stops responding, requiring a OS reboot to fix

I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out. There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
0
votes
1answer
346 views

I can't install db-mysql in node.js

When I execute this command: npm install db-mysql, I get the following result. What's the solution to this problem? C:\Users\Mouad>npm install db-mysql npm http GET https: ...
-3
votes
1answer
245 views

Windows Server 2008 R2, Active Directory, and Oracle Database Server

I have a group of clients, Windows server 2008 R2(Active Directory Installed in it), and an oracle database Server I Want to know how to make the configuration of the following Diagram in this link: ...
1
vote
1answer
48 views

MySQL-test suite not included with windows mysql installer?

I noticed in my MySQL folder there is no mysql-test. Why is that? Is it possible to add it?
2
votes
1answer
256 views

Trying to allocate 3G for buffer pool in InnoDB fails

I'm trying to boost my InnoDB driver on my Windows 7 PC since each page request takes just about 1.7 seconds to load versus 0.002 seconds on my Ubuntu 12.10 workstation. The setting I'm playing ...
5
votes
1answer
7k views

How to resolve ORA-01031: insufficient priviledges error on Windows installation?

I installed Oracle 11G on my Windows 2008 R2 Server. I also installed Oracle Client Libraries using separate installation media. After the client installation, when I try to log into the database ...
1
vote
2answers
245 views

Performance Counters for SQL Server Related to iSCSI Disk Access

I am planning to my SQL server databases (plus TLogs and TempDB) to a new LUN on our iSCSI SAN. The current LUN's used by these of these files are on their own two disk RAID 1 disk group and I'm ...
2
votes
1answer
359 views

MySQL backup InnoDB

I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full ...
0
votes
0answers
522 views

Install PostgreSQL 9.2 on Windows using WIN1252 encoding.

I had installed PostgreSQL 9.2 earlier and it always installed with the encoding being WIN1252 (the default database was WIN1252). I then some time ago reinstalled it with the encoding being UTF8 (I ...
3
votes
4answers
618 views

Stress Test to Saturate Memory for MySQL InnoDB

I'm investigating windows 32bit memory problems (the 2G limit) and am after a test which will max out MySQL's memory including InnoDB Buffer Pool, per connection memory and/or any other uses of ...
0
votes
1answer
277 views

Logging and saving user activity

Database:Oracle 11gR2 OS: Windows 2008 Server R2 I'm not trained DBA, just have to run things on an Oracle database temporarily, which is used to perform OLAP processes. I need to automatize user ...
1
vote
2answers
778 views

How do I add a database in IBM DB2

I'm supposed to migrate a MySQL database into IBM DB2, but I thought I'd take baby steps first before I do something like that. So for now, I'd just like to add a database. I'll admit that I have no ...
0
votes
1answer
935 views

How to copy MySQL Database from Linux to Windows?

I would like to copy a MySQL database form Linux to Windows, from a little research I found this url http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html where the author says we ...
4
votes
3answers
349 views

STARTUP command fails : Why is that?

I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using Oracle. Earlier I have used MySql and MSSql and I bet this one is a lot different ! These are the ...
1
vote
1answer
282 views

Unable to start Oracle Database Server : Get an error as I try to start it

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop : but as I click this icon I see this dialog box : What is it ? How do I ...
1
vote
1answer
122 views

INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' not working

I'm trying to install semi synchronous replication in my mysql 5.5 and trying to execute the below command: INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' but this command is ...
3
votes
1answer
202 views

Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]

SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
1
vote
2answers
2k views

Mysql Can't create test file + 1067 Error

I have installed mysql-5.5.30-win32. All works fine until i create my own my.ini configuration file. When I am trying to start the service using CMD (I do run the cmd as administrator, and install the ...
2
votes
1answer
95 views

How does MySQL resolve schema information?

I’ve used MySQL on windows7. Recently my machine was infected by a virus. After that SHOW TABLES and SHOW DATABASES statements don’t show any tables and databases but I can see data from tables ...
2
votes
2answers
988 views

issues with encoding and pg_dump/restore between windows and linux

I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
1
vote
2answers
4k views

MySQL Installation error: Unable to update security settings

I tried to configure MySQL server 5.5 on Windows and this is what I get mysql-server-5.5-winx64:56 - Attempting to update security settings. mysql-server-5.5-winx64:100 - Unable to update security ...
9
votes
1answer
153 views

What platform for a large record based mathematical database?

Hi I am a civil engineer with some experience of programming but I am not familiar with the vast range of options available today. Hope you could give me any pointers the best way to proceed. I want ...
4
votes
1answer
905 views

Continuing failovers on production server

At least a few times a day, my main production server has recently begun failing over. Only, the quorum doesn't move to the other node. I ran the validation report, and got a lot of info I don't ...
0
votes
1answer
380 views

MongoDB Master and Slave Replication - Windows or Linux

I have recently moved my MS SQL Server Database to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...