Operating system produced by Microsoft. Windows is produced in various desktop and server versions.
25
votes
3answers
2k views
On a dedicated database server, how much memory to reserve for the OS?
Assuming you have a dedicated server explicitly for database functions -- how much memory should you reserve for the operating system?
I realize this will probably vary somewhat depending on the ...
14
votes
3answers
19k views
Recommended page file size for SQL 2008R2 on Windows 2008R2
This Microsoft article - How to determine the appropriate page file size for 64-bit versions of Windows Server 2008 and or Windows 2008 R2 provides guidance for calculating the page file size for 64 ...
12
votes
1answer
228 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 ...
10
votes
2answers
222 views
What is shared between two instances on the same server?
We want to install multiple instances of SQL Server on a single Windows server. We cannot use VMs because the server is bare metal Windows 2008 R2.
For security purposes we need to ensure that the ...
10
votes
1answer
275 views
What does a SQL Server DBA need to know about Windows Server?
Analogous to my previous question What does a DBA have to know about SSAS?, which generated a really wonderful answer (thank you, @ConcernedOfTunbridgeWells!), I now ask a similiar question:
What ...
9
votes
5answers
1k views
SQL Server command line usage? Is it possible?
I've been trying to use the SQL Server Management Studio 2008's built in "Solution Explorer" to manage a project and after 2 weeks of struggling with it, I've decided I don't really care for it. It's ...
9
votes
1answer
127 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 ...
7
votes
3answers
1k views
What Mechanism does MySQL use to schedule Backups on Windows Server 2008?
When scheduling database backups on MySQL Server (v5.1.45-community) running on Windows Server 2008, what mechanism is used to trigger the backups to run? I think it's using the Windows Task ...
6
votes
2answers
733 views
securely exposing sql server 2008 for windows authentication
My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet.
We have sql ...
6
votes
3answers
3k views
Installing default MySQL Tables in Windows (mysql_install_db)
In Linux, the default MySQL grant tables can be created with the mysql_install_db script, but that does not work on Windows.
How can the default grant tables be installed on Windows?
(No, I’m not ...
6
votes
2answers
224 views
Can Oracle be installed on Windows without being an administrator?
Can the oracle software be installed on windows without having administrator privileges?
6
votes
3answers
4k views
PostgreSQL: The database cluster initialization failed
Both C:\PostgreSQL and C:\PostgreSQL\data have postgres user with full access and admin rights.
I ran postgresql-9.1.2-1-windows.exe from postgres user as admin. Target C:\PostgreSQL
Every way I ...
6
votes
1answer
366 views
Login to SQL Server 2k8 R2 SP1 via Active Directory Group
I added an Active Directory group as a Windows Authentication Login to our SQL Server 2008 R2 database.
When a user who is a member of that group tries to connect to the server he is given a login ...
5
votes
2answers
7k views
Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”
The dbconsole is configured and started, but when I navigate to it, Internet Explorer shows the page stating that "Internet Explorer cannot display the webpage". This is the error that means that IE ...
5
votes
4answers
7k views
Why does MySQL say I'm out of memory?
I was trying to execute a fairly large INSERT...SELECT in MySQL with JDBC, and I got the following exception:
Exception in thread "main" java.sql.SQLException: Out of memory (Needed 1073741824 bytes)
...
5
votes
2answers
105 views
New Cluster Testing - Best Practice
We've finished setup of a 4-node SQL Server 2005 cluster. We are using Windows 2008 R2 as the underlying OS.
We are looking for suggestions on a set of tests we could perform to test failover of the ...
5
votes
1answer
578 views
Case Behavior Changed Between 11.2.0.1 and 11.2.0.2
I have a case open with Oracle and they say they can't reproduce this. Running the following in 11.2.0.1 or lower produces two rows from both of these queries, but in 11.2.0.2 the second query ...
5
votes
3answers
661 views
How can a datapump export have its resource usage limited on windows?
Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
5
votes
1answer
548 views
Is there a way to edit the System Database Directory for DB2?
We have a case where we want to try to get rid of a database. The database still exists on disk and when we catalog it, it re-appears in the Database Manager. But when we try to do a DROP on it, it ...
5
votes
1answer
372 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 ...
5
votes
1answer
226 views
Migrating MySQL to new server
We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows Server 2003 R2 (Server B).
We have a new MySQL 5.5 instance on ...
5
votes
1answer
1k views
Is it possible to synchronize two ms access db?
We have a flower store where we use MS Access and a client program to work with the database. But this program can work only with one database.
We are going to open a new store, so now we have to ...
4
votes
2answers
148 views
Display all tables and their columns
Is there a way to display the layouts for all the tables to see their columns? I am trying to find tables with a certain column names.
I am using the web app Web Data Administrator
Example:
table1
...
4
votes
2answers
644 views
Does the PCI standard forbid the use of Windows Authentication?
We currently use Mixed Mode for our SQL Server Authentication. I've tried to convince our DBA to allow us to use Windows Authentication so we can use Team Foundation Server, however he absolutely ...
4
votes
2answers
12k views
How to connect to a remote Oracle server from Windows machine using PL/SQL Developer?
I understand that I need to configure database address in the TNSNAMES.ORA file but where should I put this file?
UPDATE
I defined the $TNS_ADMIN variable, created the TNSNAMES.ORA file, added new ...
4
votes
2answers
1k views
Import Oracle full dump file to fresh Oracle installation
I am importing a Oracle dump fill created on a AIX Oracle 9.2 installation with a Full Export option to a Windows Oracle 10.2.0.4 on Windows 2008 R2 x64.
I want to import the file to a clean ...
4
votes
1answer
374 views
Not all members in a Windows group have permissions
I ran into a bit of an odd situation. Let's say I have a domain group [DMN\Group] which has been created as a login on my server and a user in the database. One of the members in that group is not ...
4
votes
1answer
465 views
How to restore a SQL Server 2008 R2 database
Here's my issue.
I have a server created from a windows image that includes SQL Server 2008 and two specific windows users, these windows users are a part of the sysadmin role and are users for the ...
4
votes
1answer
1k views
Windows Authentication for a non-local non-domain Login
I have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network.
Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain ...
4
votes
1answer
66 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
1answer
93 views
MySQL year 2038 vulnerable
I was studying Drupal and asked this question:
http://drupal.stackexchange.com/questions/45443/why-timestamp-format-was-chosen-for-users-created-field/45446#45446
I decided to check, how the CMS ...
4
votes
3answers
74 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
267 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
140 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
602 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 ...
3
votes
2answers
340 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
2answers
410 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
1answer
477 views
MySQL Server Backup
I was wondering if there was any way of making a backup of an entire MySQL Server at regular intervals to a specific location. (If the version is required I can get it easily).
If there is, I must ...
3
votes
2answers
277 views
Problems connecting to Windows-based Postgresql
Other computers are having trouble even finding the running Postgresql 9.1 on my Windows 7 machine. Local connections work just fine of course.
In my pg_hba.conf I have:
#office subnets
host all ...
3
votes
1answer
91 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
702 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
306 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
1answer
573 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
2answers
110 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
275 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
131 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
2k 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
2answers
8k views
How do I reset the postgres password for PostgreSQL on Windows?
I have installed PostgreSQL on my Windows machine for development. Now I haven't used it for a while, and have forgotten the password for user postgres (default admin user in PostgreSQL). How can I ...
3
votes
1answer
2k views
WAMP server performance tuning for MySQL
We have a Drupal site with nearly 2000 pages running on WAMP server. The pages also contain images, and flash videos embedded into them. So, they are taking some time to load under normal settings.
...
3
votes
2answers
751 views
ORA-04031: unable to allocate bytes of shared memory (“”,“”,“”,“”)
I am receiving this error in a development database.
It happens on some specific queries (simple inserts and deletes via .NET application).
The database is used by one user, and error happens ...
