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

learn more… | top users | synonyms

4
votes
1answer
76 views

Internals of Windows-to-Windows SQL Server data transfer

This is a sort of generic question and I don't require a very specific answer, but let me ask it by describing a scenario. You connect to a remote db in SQL Server Studio 08, and run a select * ...
4
votes
3answers
810 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 ...
4
votes
1answer
29k views

How do I grant all privileges to local db2admin with DB2 9.7 on Windows?

I have as my developer station a laptop with OS Windows XP Professional Edition, Service Pack 3. I have downloaded and installed IBM DB2 UDB 9.7 fix pack 4, of the Express-C edition. I have a local ...
4
votes
1answer
2k 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 ...
4
votes
1answer
393 views

I have multiple ibdata files : What should I do with them?

I have 3 different ibdata files on disk. What is the difference between them? Can I remove some of them? The goal is to migrate the files from C: to E:... I'm on MySQL 5.0.x... Directory of C:\MySQL ...
4
votes
1answer
1k views

Oracle Database Enterprise Users & Roles with Microsoft Active Directory?

We have a legacy application and we have full access to source code and platform running it, so virtually any change can be implemented if required. The application is a Java Swing heavy-weight GUI ...
4
votes
2answers
2k views

Separate tables or partition one huge table?

I'm building a rather large table that includes a particular column, my_column. There are a small-ish number of possible values for my_column, and each unique value of my_column should have the same ...
4
votes
1answer
690 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
4
votes
1answer
145 views

ProcessID Owner with third party app

I am having problems trying to audit a third party app with a SQLServer backend. The app manages users and user access via a SQL table, using a single SQL login to access the databases. I am trying ...
3
votes
2answers
6k views

Dynamic change to innodb_flush_log_at_trx_commit

This is related to this question. It does help to get better performance for InnoDB tables. According to MySQL manual, innodb_flush_log_at_trx_commit is a global dynamic variable. Thus, I can change ...
3
votes
2answers
578 views

Testing Query Speed

When I'm running a query for the first time, it takes x miliseconds to be executed. When I run it the second time it takes a lot less time. I assume that it is some caching involved in this mechanism, ...
3
votes
3answers
4k views

Can I specify a different disk for a specific MySQL table?

I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...
3
votes
2answers
425 views

How much RAM I should assign to SQL Server 2008 running on W2K3

I'm planning an installation for SQL 2008 over Windows 2003. The server has 16g RAM. How much RAM I should assign to SQL server?
3
votes
3answers
461 views

PostgreSQL 9.0 how to reclaim disk space after delete without rebuilding table?

Our PostgreSQL 9.0 Windows production server is running low on space. In our 100GB database, we have a large table containing TOASTed binary data. We have deleted some rows and need to return the ...
3
votes
1answer
10k views

Change existing datadir path

I want to change the datadir path in the my.ini file. The existing datadir path is C:/ProgramData/MySQL/MySQL Server 5.1/Data/ The size of my C: drive is 30 GB and the MySQL data folder is occupying ...
3
votes
1answer
674 views

Login problem to SQL Server

I attempt to connect to SQL Server 2008,I receive the following error. Login failed for user <>. Reason: Failed to open the explicitly specified database. By the way, I have a SQL Server 2008 ...
3
votes
1answer
379 views

pg_dump freezes on windows service application

I have a system running over Tomcat which executes a backup batch job every day, it calls pg_dump.exe from Java and stores its output to an SQL file. When I'm executing Tomcat from the shell, it ...
3
votes
1answer
130 views

migrating from SQL server 2005 to 2008

I had SQL server 2005 installed on my windows server 2008 R2. Recently i installed SQL server 2008 and SQL server management studio 2008 r2 (SSMS) on my virtual server and i configured the instance ...
3
votes
1answer
1k views

oracle failsafe - how to start instance in nomount

Using Oracle Failsafe, how can a instance be started up in nomount mode? If the instance is shutdown via sqlplus, the windows cluster manager just starts it up again. If the instance is shutdown via ...
3
votes
2answers
372 views

Windows Storage Server, SQL Server, regular files — means to protect from insider threats?

This is my first post here, and I am by no means qualified as a Windows Server or Storage Server 2008 or SQL Server 2008 administrator. I am mostly a Unix guy, however tasked with a job to investigate ...
3
votes
2answers
131 views

I'm performing a post-mortem on an Oracle database that's crashed its' host. Where should I begin?

I have an Oracle database (10.2.0.1.0 I believe) on a Windows 2003 server that I believe has successfully crashed the OS itself twice. Debates on platforms and stability aside, the evidence suggests ...
3
votes
4answers
857 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 ...
3
votes
1answer
7k views

Pg install: “The database cluster initialisation failed”

(Note: This question has been compeltely rewritten from its original form, so it reflects the actual problem and will help others find a solution to the same issue). I still haven't been able to ...
3
votes
3answers
6k views

Physical memory usage approaching 100%(96%) [duplicate]

Possible Duplicate: SQL Server 2008 R2 “Ghost Memory”? Context: Windows Server 2008 R2; 32GB RAM; Application: SQL Server 2008 R2, several Connectors to Write Data into SQL ...
3
votes
2answers
4k 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 = ...
3
votes
2answers
10k views

How to start Oracle database's listener service after a change in the IP address?

I'm using Windows XP as my Oracle database server. Today there was a change in the IP address if the database server. I want start my database instance's listener again. Windows XP prompst that: ...
3
votes
1answer
99 views

connection issue / Oracle Express 11g in windows7 32bit

I have an issue with Oracle Express 11g in windows7 32bit. Everytime when I try to conncet to the database I get this error message. How can I fix it please!
3
votes
1answer
2k views

MySQL Server Performance

I have a few questions regarding MySQL server running under Windows Server 2008 R2: How do I check the number of allowed connections? How do I turn on query logging to see performance of queries ...
3
votes
1answer
5k views

SQL Server 2008 R2 on Windows 7 x64 Professional - what are the downsides?

I need to minimize the cost of the platform, that will run SQL Server 2008 R2 Standard Edition. I have a special licensed version of this SQL server to work with like 20 users (it's an 1C special ...
3
votes
1answer
1k views

PostgreSQL 9 'pgstats wait timeout' problem

I'm asking about this here because in the PostgreSQL mailing lists no one answered me. In one of my servers (Windows 2008 R2 Standard/PostgreSQL 9.0.5 64 bits) the logs are being flooded with the ...
3
votes
1answer
2k views

How to find the detail cpu high process name which occupying most resource in the SQL Server database?

I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env. DECLARE @ts_now bigint; SELECT @ts_now = cpu_ticks / CONVERT(float, ...
3
votes
1answer
49 views

Problems while building plpgsql_check on Windows

I try to build plpgsql_check extension by @PavelStehule (Erwin Brandstetter recommended it to me in this answer) on Windows XP 32bit with Visual Studio 2010 (I used this article as a manual). However, ...
3
votes
1answer
346 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: ...
3
votes
2answers
2k views

Problem installing DB2Express

I installed DB2 Express 10.1 on my Windows 7 (64bit) notebook. Now after the installation finished I cannot connect to the database. During the installation I specified "C:\Daten\db\db2" as the ...
2
votes
2answers
435 views

Use different Windows account in pl/sql

Is it possible to use/log in to a different account in pl/sql. For example, I would like to write to a file in a folder only a specific account has access to. Here's an example of what I mean: Other ...
2
votes
1answer
3k views

How do we free up disk space from allocated namespace? / ORA-03297

We are running out of disk space. The server has a 420 GB HDD, and runs a Microsoft SQL Server and an Oracle Server(10g). The Oracle server uses up to 315 GB space. We have just loaded a 100GB ...
2
votes
2answers
1k 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 ...
2
votes
1answer
694 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 --> ...
2
votes
2answers
171 views

Software for backing up SQL Server databases

Since using the new version of Symantec, I've experienced lots of problems doing incremental backups of clients' SQL databases. Is Windows Server backup a good alternative to Symantec Backup Exec ...
2
votes
1answer
4k views

MySQL Workbench asking for password

I am trying to set MySQL server on my Windows 7 64 bit machine. I have downloaded MySQL server and MySQLWorkbench. I have started mysql service by command C:\> net start mysql as suggested ...
2
votes
1answer
16k views

How to import a.csv file into a postgresql database using \copy?

I am trying to import a .csv file into a postgresql database. I am using pgadmin III for that on a win7 machine. My query looks like that: \COPY pop_grid(GRID_ID, POP_TOT, YEAR, METHD_CL, CNTR_CODE, ...
2
votes
2answers
445 views

Can I implement clustering with just 2 servers and one NAS?

I have the following architecture, it consists in only 2 servers, connected to a NAS. I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do ...
2
votes
1answer
3k views

How do I create a database+tablespace+user in Oracle 11gR2?

Good evening, I'm trying to figure out how to create a database+tablespace+user in Oracle 11g. I've tried some tutorials, but nothing seems to work. I cannot find Database Configuration Assistant ...
2
votes
1answer
83 views

Bad Windows Authentication sign on

I do not have install privileges on my machine. Another user who has admin privileges installed it, but told the system to use Windows Authentication for the sign on. Is there a way they can change ...
2
votes
1answer
2k 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 ...
2
votes
1answer
2k views

Logging to a file in PostgreSQL windows service

I need an alternative for running the following command: C:\xxx\pgsql\bin\pg_ctl" -D "C:\xxx\pgsql\data" -l "C:\yyy\log\pgsql.log" start. This way the server starts and logs to C:\yyy\log\pgsql.log. ...
2
votes
1answer
509 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 ...
2
votes
1answer
494 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 ...
2
votes
1answer
97 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
3k 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 ...