Questions tagged [windows]

Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 views

Oracle listener does not restart because port 1521 is not released fast enough after stop

I'm running Oracle 11g on a Windows 2012R2 server. For some reason we have some code that try to restart the listener and then perform a connection. This code has been working for years on many ...
-1
votes
1answer
20 views

How can I save the MySQL query output to file on a Windows machine?

Let's say I want to save the whole list of the collations supported by MySQL into file. How can I save the result of the show collation into .txt file? The OS I'm using is Windows. I tried something ...
0
votes
0answers
12 views

MySQL server on Microsoft Surface Pro X (ARM-64) work around?

I've been given a surface pro X laptop/tablet(?) which has been purchased for one of the hands-on finance directors who like to browse the database for the company I'm working for. On the looks of it ...
0
votes
1answer
15 views

What steps are required to setup PostgreSQL and create a db in Windows?

I have installed PostgreSQL 12 from https://www.2ndquadrant.com/en/blog/pginstaller-install-postgresql/. and put \C:\...\PostgreSQL\12\bin in the PATH. In an admin powershell I execute psql.exe -U ...
0
votes
1answer
12 views

Why pgadmin dont enter in admin panel?

I install postgresql-12.4 on my win pc. When i'm trying to enter into admin panel (pgadmin) i cathcing message: could not connect to server: Connection refused (0x0000274D/10061) Is the server running ...
0
votes
0answers
36 views

Innodb error log sequence number is in future

2020-08-28 16:46:02 d64 InnoDB: Error: page 1 log sequence number 23113680 InnoDB: is in the future! Current system log sequence number 3181581. InnoDB: Your database may be corrupt or you may have ...
-2
votes
0answers
12 views

MySQL stops in windows VM and shows innodb error log sequence number is in future [duplicate]

2020-08-28 16:46:02 d64 InnoDB: Error: page 1 log sequence number 23113680 InnoDB: is in the future! Current system log sequence number 3181581. InnoDB: Your database may be corrupt or you may have ...
0
votes
0answers
28 views

pg_repack binaries under windows

We use postgres to manage our data in windows. Most of our installations run 9.x branch of postgres, although all versions of the database software is used (however pretty much all installations run ...
0
votes
1answer
21 views

MySQL stops in windows VM and shows innodb os error in logs(error no. 5)

2020-08-23 17:22:36 5688 [Note] Plugin 'FEDERATED' is disabled. 2020-08-23 17:22:36 5688 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-08-23 17:22:36 5688 [Note] InnoDB: The InnoDB ...
4
votes
1answer
336 views

How do I prevent my Windows Server from being automatically rebooted by SQL Server updates?

Some SQL Server updates have happened outside the maintenance window, which have caused the server to be rebooted. How can I stop this from happening again in future? Below is what I can see when ...
0
votes
1answer
16 views

PostgreSQL for windows create tablespace on network location (nfs shared) failed because directory not exist

My server is Windows Server 2016. The server mounted a NFS remote storage with below command: mount \\192.168.6.68\nfsshare z: mkdir z:\pg_data All the relevant permissions such as read/write/execute ...
0
votes
0answers
19 views

Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE' vulnerability for Windows 2008 R2 SQL

I have a MSSQL Windows 2008 R2 server. Vulnerability for "Ensure 'Adjust memory quotas for a process' is set to 'Administrators, LOCAL SERVICE, NETWORK SERVICE'" has been found. Current ...
0
votes
3answers
60 views

Can't start Oracle after Virtual Machine restore

As part of a project for a customer of mine, they've given me the complete backup of a physical server (taken by Veeam) which I have then used to make a Bare Metal recovery onto a test VM host I have ...
1
vote
1answer
135 views

Cant install SQL Server 2019

I have a single node Windows 10 Pro machine, 64 bit, with 32GB Ram and an i7 processor. When I try to install the developer edition of Sql Server 2019, it fails installing the Database engine with a ...
0
votes
2answers
31 views

Windows Server 2019 and SQL Server Backups issue?

I have an issue with SQL Server that is really driving me nuts so I wanted to ask if anyone has any suggestions. I have a program that does a daily backup of the SQL Server database. This has worked ...
0
votes
0answers
9 views

Change to sa and windows authentiction

I am trying to enable sql server and windows authentication mode by logging into SSMS but when I change to sql server and windows authentication mode and hit OK, I get this pop up enter image ...
0
votes
1answer
12 views

Where is MySQL template directory for pristine Data?

I'm using MySQL 8.0 in Windows. I'm trying to set up multiple servers. And I need to copy the Data directory for it. The MySQL documentation says Windows MSI package installers create and set up the ...
2
votes
0answers
41 views

Cannot access MYSQL safe mode using skip-grant-tables on Windows

I am running a MySQL server 8.0.21 on a Windows Server system. Recently I ran into an issue where my root user lost all its privileges. I am trying to gain access to the MySQL server using: mysqld ...
0
votes
0answers
10 views

Run MongoDB under a Windows Managed Service Account

In Windows environment can I run MongoDB under a Windows Managed Service Account? the main reason is there is a company policy about PWD expiration each 60 days, and we want to use Managed Service ...
0
votes
0answers
30 views

upgrade from 9.4 to 9.6 using pg_upgrade fails

I'm using pg_upgrade to upgrade postgresql from 9.4 to 9.6.Both versions are installed on windows server 2016.I followed the steps described in https://www.postgresql.org/docs/current/pgupgrade.html. ...
0
votes
2answers
28 views

Move Oracle to new drive

I have a customer who currently runs Oracle on Windows (not my choice, I just have to deal with their current setup) The basic layout of the server C:\ - operating system and oracle application D:\ - ...
0
votes
1answer
36 views

Need to upgrade SQL Server from 2012 to 2017 on a Server 2008 box

I have been asked to upgrade SQL Server from 2012 to 2017, it is currently installed on a server with Windows 2008 OS. My thinking from what I've researched is this: Take a snapshot of the server ...
0
votes
1answer
14 views

Why mysql-noinstall5.6.x.zip includes ibdata file?

English is not my main language, please feel free to correct me or ask for clarification or a different explanation. I've been messing around with MySQL for Windows and trying to understand how it ...
1
vote
0answers
43 views

PSQL console encoding

How can I have a working PSQL console using UTF8 encoding under Windows? I have a Windows server and client. The Postgres 12 database contains tables with content in multiple languages (ex: English, ...
1
vote
1answer
14 views

can I exclude or delete .pem files in backup data myqdl?

I am making a backup of the mysql data folder. In this folder are the databases. The method I am using is described in this post which uses ROBOCOPY During installation, mysql (tested in 5.7.30) ...
0
votes
0answers
49 views

Powershell script hangs with psql command, continues only after hitting enter

I have a simple powershell script that is supposed to drop an existing schema and restore it from a backup, the script is basically those lines: echo "Dropping Schema MySchema" & $PG_SQL -d "host=...
3
votes
3answers
153 views

what files should I exclude/add/copy mysql dbs (without mysqldump)

I need to have an exact copy of my databases in a clone VM of my server (just in case the server goes down, have the VM ready with the dbs). I know that mysqldump is the best alternative to migrate, ...
0
votes
1answer
29 views

RMAN-03009: failure of backup command due to ORA-27038 and OSD-04010:

I'm running below script in a windows server, this is same script I run across all servers run { configure retention policy to recovery window of 7 days; backup current controlfile format 'F:\...
0
votes
0answers
22 views

How to remediate the TLS_RSA_WITH_SEED_CBC_SHA on Debian and TLS_RSA_WITH_3DES_EDE_CBC_SHA (SWEET32) on Windows?

I'm in a class right now and we're given two servers to setup and secure. We are supposed to use Greenbone Vulnerability scanner and report/fix what it finds. My windows server is vulnerable to ...
2
votes
1answer
51 views

Can you create a clustered DB in Azure using Windows 2003 and SQL Server 2005?

We need to replicate an environment in Azure, running a clustered DB. The current physical environment is running on Windows 2003 and MS SQL Server 2005 R2. We know that there's no OS/DB support but ...
0
votes
0answers
23 views

How to get the table change script for SQL Server using SSMS 2017?

I'm having frequent table changes in my database, I'm using SSMS 2017, is there any easy mechanism for generating scripts for the changes made to the table. Or Are there any tools for managing this ...
0
votes
1answer
15 views

Mongodb as windows service

I am using mongo db with replica sets. I am starting the mongodb using command prompt. Python Script: os.system('start mongod --configsvr --dbpath C:\mongoConfigData/configdb1 --replSet conf --port ...
2
votes
1answer
68 views

How am I supposed to update PostgreSQL on Windows, once installed, without manually installing new installers?

I have PostgreSQL 11.5 installed on Windows 10. It was installed with the EnterpriseDB installer, which is the only one which exists these days. If I go to https://www.postgresql.org/download/windows/...
0
votes
0answers
344 views

Postgresql 12.2 “Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed” on windows 10

I get this error whenever I try to install Postgresql 12.2 "Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed". I followed ...
0
votes
1answer
21 views

Recover raw Databases from corrupted MySQL 8 + Windows Server Implementation

I have a (Virtualized/Hyper-V) MySQL 8 (8.0.16.0) DB server whose installation has become corrupt and will no longer start the service, or report any errors as to why it won't start (this is a virtual ...
3
votes
1answer
90 views

Should I disable filesytem journaling for MS SQL Server (Linux/Windows)

For a PostgreSQL server installation on Linux, it is beneficial to disable filesystem journaling. Tip: Because WAL restores database file contents after a crash, journaled filesystems are not ...
0
votes
0answers
25 views

oracle 12c enterprise manager default login

I am just installed oracle database in my windows machine after installation it i can't able to login i dont have username only i know password . can any body help on this advance thanks
2
votes
0answers
611 views

SQL Server - allocation unit size in Windows 2019

I'm about to install a SQL Server 2019 instance on a Windows 2019 machine and found out that there are new ntfs allocation unit sizes available - up to 2M. I used to format partitions using 64k unit ...
0
votes
1answer
26 views

Do we need to shutdown DB/Stop DB service before Windows server patching

Before patching Windows server, do we need to shut down any DB or stop DB service. If we need to shutdown a MongoDB on a node(Windows server) which is part of a replica set, what we need to before ...
0
votes
0answers
209 views

Getting “unknown variable postgresqlini” when updating PostgreSQL

I am getting an error when attempting to upgrade a PostgreSQL installation. The full error is: A data directory is registered in ***unknown variable postgresqlini*** but is neither empty or a ...
0
votes
1answer
92 views

How to resolve MDF and LDF files remaining in use?

I am attempting to copy off approximately 220 gigs of database MDF and LDF files from a MS SQL server 2000 install in order to transfer ownership to a third party. The error I get when I try to stop ...
1
vote
1answer
67 views

Reset mongo cache memory for test perfomance - windows

recently i'm working on mongo db and I'm trying to check the performance of mongodb with 2 million record. I need to clear cache every time I start the test. I don't want to restart the computer/...
0
votes
2answers
59 views

Load PostgreSQL database from corrupt drive [duplicate]

I suffered corruption of a hard drive but managed to recover files for a PostgreSQL server. We are running on the assumption that the files themselves are not corrupted (yet to be able to tell). My ...
0
votes
0answers
11 views

posgres instance is listening to old port even after changing to new port number

My machine is having posgres server 11th version,for testing purpose i installed another posgres instance(12 version )in same machine.i changed port number of this new instance to 5433 but when i try ...
3
votes
1answer
295 views

In the context of another principal what permissions hinge on the identity of the database owner?

By "database owner", here, I mean the principal whose SID is sys.databases.owner_sid. This answer to the question of best practices for database ownership includes the following: The answer here ...
13
votes
2answers
2k views

Why is database ownership by groups not allowed? Which user should own a database?

Per microsoft "ALTER AUTHORIZATION for databases for SQL Server": Requirements for the new owner: The new owner principal must be one of the following: A SQL Server authentication ...
1
vote
2answers
2k views

Building Oracle XE docker image in Windows 10 Pro

I'm trying to install Oracle XE 18c in a docker container in Windows 10. I have docker already installed, and I need to build the image as explained here. I cloned the git repository, but I'm stuck ...
0
votes
0answers
37 views

Ingres ODBC driver not working

I recently installed an Ingres database as part of an application install. When I try to view its ODBC though it returns the following screen. A majority of the text has been replaced with ERget: ...
0
votes
1answer
94 views

Secure postgres 9.5 database packed on Windows desktop application

My desktop app includes a postgres database and a front app. I need the db to be accessed only by my front app. The credentials of this user are going to reside in the front app binaries. I realized ...
-1
votes
1answer
23 views

Trying to perform an update command on MySQL to insert a column of data is taking over 5 minutes. What can I do to debug this?

I have an application where it join two tables from two different MySQL DBs and with the resulting table from that join, update a column on another table in another DB. The resulting data from the ...

1
2 3 4 5
12