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
1
vote
1answer
12 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
21 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
149 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
13 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
12 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
10 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
22 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
60 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
19 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
67 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
13 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
226 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
22 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
73 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
83 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
43 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
49 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
290 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 ...
2
votes
1answer
853 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
30 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
92 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 ...
0
votes
0answers
31 views

Hyper-V Live-Migrating MongoDB Server

Does anyone know if DBs in general or in this case a Centos 7.x box running mongoDB would have corruption or any issues for that matter, if Live migrated from one host to another ? These are hosted ...
1
vote
1answer
177 views

Different default innodb_buffer_pool_size on Windows with MySQL 8.0.18

I have installed MySQL 8.0.18 Community with the same configuration (mysql-installer-community-8.0.18.0.msi installer, custom install with server + workbench, standalone server, legacy authentication, ...
1
vote
1answer
37 views

Programming query execution Postgres

I need to execute update querys routinely over a Postgres table. Is it possible to program an automatic execution of the query, let's say, every day at 15:00 hs? The Postgres version is 9.5, I'm ...
0
votes
1answer
28 views

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene?

Why is it necessary to run both mongod and mongo.exe in windows? What's happening behind the scene? What's the difference between these two?
0
votes
1answer
296 views

How to have more verbose logs for mysqld startup

I have installed MySQL 8.0.17 via the official installer for Windows. I am starting MySQL like this mysqld --log-error-verbosity=3 \ --console \ --defaults-file='c:/mysql/etc/my....
0
votes
1answer
216 views

SQL server agent unable to establish connection [closed]

I have recently installed sql server 2014 enterprise version on windows 2016 server. For some reason sql server agent is not starting but sql server service is up and running. I am not really sure ...
0
votes
1answer
29 views

Oracle 11g connectivity over windows based client-server net [closed]

I have two PCs as follows: I want to create network for both PCs and share Oracle database from PC1 PC1 (windows 10 Pro 64-bit operation system) - Oracle 11g Installed PC2 (windows 10 Pro 64-bit ...
0
votes
0answers
45 views

Adding login of a pc on the network - Microsoft SQL Server Management Studio 2014

I have a small office network and I am trying to add new logins for the other PCs on Microsoft SQL Server Management Studio 2014 (all computers are Windows 7). I cannot seem to find the other ...
0
votes
2answers
107 views

How to use pg_archivecleanup on Windows

Trying to figure out a proper way to clean old WAL files located in archive directory for point in time recovery purposes. I know I can use hard-coded name of WAL segment something like this: ...
1
vote
1answer
2k views

pgAgent service for PostgreSQL does not run

OS: Windows 10 PostgreSQL 11.4 I Installed PgAgent with Stackbuilder setup. In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start ...
0
votes
0answers
299 views

Unable to start PostgreSQL service after pgAgent installation

I had Postgre running just fine on my Windows 10 (64-bit). Then I tried to install pgAgent via the stackbuilder for postgres. I got some error that it was not able to create a .conf file under %\...
1
vote
1answer
77 views

mysql workbench - Couldn't find option to remove DROP TABLE IF EXIST

Recently I've been looking into export options to find an option to remove: DROP TABLE IF EXISTS and replace it with CREATE TABLE IF NOT EXISTS. I've seen on other MySQL clients like HeidiSQL or ...
0
votes
2answers
110 views

SQL*Plus - interactive mode on windows

How can I issue commands through SQL*Plus on Windows? In Linux is like this: sqlplus -s /nolog<<EOF conn username/password@database EXECUTE some_proc; EXIT; EOF And Windows?
1
vote
1answer
419 views

Windows Login can't access SQL Server even with SYSADMIN role

I'm working on AD permissions and have removed my user account from the Domain Admins security group. Now I'm having difficult accessing my SQL Server database with my Windows login. The login is in ...
0
votes
0answers
16 views

Trying to create 2nd instance of mariadb on windows server

I have a windows server with MariaDB (10.2.14-MariaDB) and I'm trying to install a 2nd instance on it. I have 1 instance working using port 3307. I used mysql_install_db to install it on port 3307. I ...
1
vote
2answers
812 views

Locale is incompatible error in Postgresql 10 when replicating from Ubunu to Win 10

The locale available in my Ubuntu PG-10 DB is en_US.UTF-8. When doing PG_Basebackup to a PG-10 DB in Win-10, Psql failed to connect with error psql: FATAL: database locale is incompatible with ...
0
votes
0answers
96 views

missing the OracleOraDB12Home2TNSListener service

I have just completed the installation of the Oracle 12c database, following this tutorial. My OS is Windows 10. The installation has completed successfully, only green ticks. The problem is that, ...
0
votes
2answers
2k views

Postgres Windows post-install “The database cluster initialization failed”

I've seen many solutions and have been working on this issue for hours now. After installation the post-installation script fails with the message above. This is a development installation of ...
0
votes
1answer
83 views

Move Mysql database from Windows Xampp to Linux MySql Server

I 'am looking for a way to move some database in my local xampp to remote MySql Server , running into a Linux VM (Centos 7) Any idea or any suggestions to do this migration?
1
vote
1answer
155 views

Dynamic quorum and Dynamic witness in Always On AG 2016

I have a Always On AG 2016, configured on Windows Server 2012 R2 – 2 node cluster. Quorum configured as 2 nodes + Fileshare witness, totally 3 votes. Scenario 1: Now, either 1 node fails – remaining ...
1
vote
0answers
361 views

Oracle 18 on Windows with long hostnames doesn't talk to the local listener?

Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
0
votes
0answers
654 views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
2
votes
1answer
124 views

SQL Server Demo Environment on Docker Desktop (Win 10): DB storage und upgrade paths

I would like to run SQL Server 2019 on my work as well as my private machine (both running Windows 10 Pro). Thus I thought Docker Desktop would be a nice option. However I would like to keep the ...
2
votes
1answer
559 views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...

1
2 3 4 5
12