Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
2
votes
0answers
527 views
Copy database wizard between servers results in Access Denied error. [closed]
I'm trying to copy a database from SQL Server 2008 R2 to another server, using the Copy Database Wizard in SQL Server Management Studio.
I get an error telling me to check the error log on the ...
2
votes
3answers
3k views
What's a good (free) client for Informix on Windows? [closed]
I'm looking for a GUI client for Informix on Windows (mainly to view data and execute queries), free would obviously be nice but I know Informix is used mostly in corporate environments and free may ...
1
vote
2answers
1k views
Oracle Forms 6i on Windows 7
Given I have a system of Oracle Forms 6i (legacy software), how could I make it work on Windows 7. We have serious problems with apps like PLUS80.exe crashing ("Oracle SQL*Plus has stopped working").
...
1
vote
1answer
62 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 ...
1
vote
1answer
69 views
Reconciling dm_os_windows_info windows_sku values, gathering same info from pre SQL Server 2008 R2 instances
I'm developing an inventory system for RDBMS deployments. I'm starting with SQL Server, and later will be pulling in info for Oracle & other RDBMS deployments. When you query [dm_os_windows_info] ...
1
vote
1answer
258 views
Failure to detach database
I used sp_detach_db to detach SQL Server 2005 databases. This works properly in Windows XP and Windows 7.
However, the same fails in Windows Server 2008.
The error message states:
The process ...
1
vote
1answer
246 views
Change root password of mysql database
This could be a Rookie problem , but it seems that i am not able to solve it.
I have MySQL server installed on my windows machine(MySQL 5.5) under the Admin username root.
Some How i lost the ...
1
vote
1answer
42 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
2answers
118 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 ...
1
vote
2answers
205 views
“In Use” memory on a SQL Server box
I have a SQL Server 2012 database server with 64GB of RAM. A process called DataPumpService runs on the same box and loads around 400 million records from 2700 flat files.
I want to understand what ...
1
vote
2answers
139 views
Why Oracle 11g installs in folder C:\app\<name_of_user>
Just curious, now Oracle 11g installs by default in folder C:\app\
Why? Before, Oracle was installed by default in folder C:\oracle... Why now is created "app" folder?
1
vote
3answers
621 views
Workarounds for setting default schema for domain group?
I am currently working on a project for a client, they have asked me to change the database from Oracle to SQL Server. So we migrated the database across to SQL Server 2008, when this was migrated ...
1
vote
1answer
337 views
Enterprise Manager Database Control on host with an underscore in it's name
I know it sounds awkward, but Enterprise Manager is refusing to be set up because of an underscore in the server name:
C:\>emca -deconfig dbcontrol db -repos drop
STARTED EMCA um 30.05.2012 ...
1
vote
2answers
415 views
MySQL Database and Table Loss
I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I ...
1
vote
1answer
2k views
How can I configure PostgreSQL 9.0 to start automatically under Windows XP?
Yesterday I installed PostgreSQL 9.0 on Windows XP, and after the installation the DB was running. After booting the system this morning, the data base server did not start automatically.
How do I ...
1
vote
1answer
100 views
Determining the full postgresql size on windows
While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB.
I do not use postgresql myself, I just use a tool that need a ...
1
vote
1answer
385 views
Connect to SQL Server using OLEDB or ODBC?
We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead of OLEDB to connect to the SQL Server 2008 R2 Database. The company has several databases ...
1
vote
1answer
131 views
Connection to MySQL Remotely
I want to connect to MySQL Server hosted on a Linux Machine from my Windows Machine using Command Prompt with the following command:
prompt>mysql -u root -p -h remote_hostname
Connections, ...
1
vote
1answer
65 views
Log Custom SQL Results During Maintenance Plan
I would like the last step of my Maintenance Plan to execute a simple custom SQL script (SELECT * FROM <SomeTable> WHERE <Condition>), and save the results to a file (Text, CSV, etc).
Is ...
1
vote
2answers
566 views
Which oracle should I download for windows 7 x64?
My os is: windows 7 x64
I tried to download oracle and install it in my computer, but I have downloaded 3 different oracle releases(including oracle 11G), they can't be installed.
They reported ...
1
vote
2answers
2k views
How is localhost resolved by Oracle listener?
When I o an Oracle test installation on a Windows server accepting mostly the defaults, I end up with a listener.ora like
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = ...
1
vote
1answer
2k views
How to upgrade MySQL to newer version on existing database
I am having data of 20 GB with MySQL version 5.0.24.
Now I want to update MySQL to newer version 5.5.16.
We can do it by taking complete database backup and uninstall old MySQL and install new MySQL ...
1
vote
1answer
54 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 ...
1
vote
1answer
33 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 ...
1
vote
1answer
69 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 ...
1
vote
2answers
1k 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 ...
1
vote
1answer
355 views
Is there a progress indicator for OPTIMIZE TABLE progress?
MySQL 5.1.4x (Windows) | Innodb
I recently purged data from a mySQL DB (a few hundred thousand rows) and I'm planning to use
OPTIMIZE TABLE LOGTABLEFOO1,LOGTABLEFOO2,LOGTABLEFOO3;
to reduce the ...
1
vote
1answer
68 views
Does Microsoft Security Bulletin MS11-049 affect SQL Server 2008 SP3?
The security bulletin does not list SQL Server 2008 SP3 under affected software but it came out prior to that service pack. We are running SP3 but this issue is still showing up on a vulnerability ...
1
vote
1answer
368 views
Permission denied in file trying to import
When I try to use \i on a file that is not in the psql.exe folder it says C:: permission denied. For example I have a file with SQL command at C:\Users\Work\Desktop\School Work\load_database.sql and ...
1
vote
1answer
99 views
Correct Selection of SQL server instance db owner login name
I am attempting to connect RSA Archer (5.2) to an instance of SQL server 2008 r2 on WS 2008 R2.
When Archer attempts it's initial connection I get -
The ConnectString property has not been ...
1
vote
1answer
406 views
Disable console output when executing a SQL file using MySQL source command
I begin by launching the MySQL command line tool:
mysql --user=myusername --password=mypassword --silent --force -b
The last -b option is used to disable beep on error.
Then I choose a database:
...
1
vote
1answer
1k views
Trying to install SQL Server 2008 Management Studio Express
On a Wndows Server 2008 R2 64 bits, I installed Visual Studio 2010 Express, which installed a SQL Server 2008 Express:
Trying to install a SQL Server Management Studio, first I'm required to ...
1
vote
1answer
162 views
Mysql 5.0 on Windows 2008
I have a problem with MySQL on Windows Server 2008 x64.
This is the first time I've installed MySQL 5.5 with performance problems. I decided to go back to the older version that worked well with ...
1
vote
1answer
291 views
Can I install sql server on Win XP machine with user profile on D drive?
Is it possible to install sql server on a windows xp machine where the user profiles are created on a non system root directory, that is, on D drive rather than C drive?
I am trying to install SQL ...
1
vote
1answer
197 views
Database Design - Creating Multiple databases to avoid the headache of limit on table size
I need to design database to store information contained in millions of log files generated by devices on trial on network.
My first approach was storing all the information in tables contained in a ...
1
vote
1answer
473 views
Very Large Log Files
I'm running Windows Server 2008 R2 and executed a large query by accident. Next, the sever ran out of hard drive space.
I now have a file in my administrtor documents (log.log) that is over 18GB. I ...
1
vote
1answer
363 views
Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP
Please refer to the diagram in the link below. While looking at my goals.
http://i.stack.imgur.com/GkVWb.png
GOAL:
Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location.
'on ...
1
vote
3answers
666 views
MySQL SSL disabled on Windows
I want to enable an SSL connection to my database. I've created SSL certificates and so on, however SSL remains disabled:
mysql> show variables like '%ssl%';
...
1
vote
1answer
1k views
64 bit Postgres 9.1 Limitions on Windows 2008 R2?
When Deploying Postgres on Windows Server 2008 R2:
Are there any limitations on windows that don't exist on Linux?
Does the postgres scale in the same way on windows as it does on Linux?
Is ...
1
vote
1answer
157 views
Appropriate Windows version for Mysql
I have a HP ProLiant DL380 G5 server and I would like to install mysql on it .
My questions are:
Which MySQL version should I install from this link for better performance, 32 bit or 64 bit?
Which ...
1
vote
1answer
463 views
How to Prevent an Ever-Growing index file (MyISAM engine) From Causing Disk Fragmentation in Windows (NTFS partition)?
We have a keep-growing table which using MYISAM storage engine.
Almost every half year, this table will crash, and need to be repaired.
I checked the defragment result reported by windows ...
1
vote
1answer
5k views
Asynch Descriptor Resize explanation
What do asynch descriptor resize wait events mean on an Oracle 11g database running on Windows 2008 R2? According to My Oracle Support, this event applies to any platform, but the description ...
1
vote
1answer
150 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 ...
1
vote
2answers
130 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 ...
1
vote
1answer
89 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
2answers
554 views
MySQL not responding, Writing to net status
I just had to reboot MySQL to regain access to some of my website. It had under 300MB of RAM used. Another product was working fine though, accessing it's own tables which are InnoDB.
Here's the show ...
1
vote
1answer
465 views
Binlog has bad magic number
I keep getting this error whenever I start MySQL.
121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled.
121028 1:38:55 InnoDB: The InnoDB memory heap is disabled
121028 1:38:55 InnoDB: Mutexes and ...
1
vote
1answer
269 views
Passing path from batch file to mysql
My batch file will contain some thing like this :
set MUSER=root
set MPASS=xprd123
set MHOST=172.33.49.55
set DB=DBName1
set MBIN=C:\Program Files\MySQL\MySQL Server 5.5\bin
...
1
vote
0answers
223 views
Restoring Oracle prod backup to test server with new database name
I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database
...
0
votes
4answers
37 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 ...
