Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Microsoft Windows is a desktop and server operating system produced by Microsoft. Common desktop versions include Windows XP, Vista and Windows 7 and the most common server versions encountered will be Windows 2003, Windows 2003 R2, Windows 2008 and Windows 2008 R2.

Two major versions of the Windows code base still supported by microsoft are based on Windows NT version 5 and version 6.

  • Systems based on the NT 5 code base include Windows 2000, Windows XP, Windows 2003 and Windows 2003 R2. This platform supports intel X86, Intel/AMD X64 and Intel Itanium plaftorms.

  • Systems based on the NT 6 code base include Windows Vista, Windows 7, Windows 2008 and Windows 2008 R2.

Most DBMS platforms are available on Windows, and some (particularly Microsoft SQL Server) are exclusively available on this platform.

667 questions
43
votes
3 answers

Forgotten PostgreSQL Windows password

This morning I’ve been trying to connect the PostgreSQL database on my Windows 7 Professional desktop. The default value is ‘postgres’, but sure enough I forgot what password I used when I originally installed it. I have googled and found a post…
AKIWEB
  • 625
  • 2
  • 6
  • 8
40
votes
4 answers

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 specific OS, the specific database software, and so…
Jeff Atwood
  • 2,374
  • 2
  • 21
  • 15
38
votes
2 answers

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 when I type \i "C:\Users\Work\Desktop\School…
Celeritas
  • 903
  • 3
  • 11
  • 17
33
votes
3 answers

MySQL creates temporary tables on disk. How do I stop it?

We are running a site (Moodle) that the users currently find slow. I think I have tracked down the problem to MySQL creating temporary tables on disk. I watch the variable created_tmp_disk_tables in Mysql Workbench server administration and the…
user30431
  • 463
  • 1
  • 5
  • 11
31
votes
1 answer

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 25 GB. So I want to change the datadir to…
naveen
  • 311
  • 1
  • 3
  • 3
25
votes
3 answers

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 bit Windows 2008 and Windows 2008R2. This no doubt…
Kev
  • 1,336
  • 5
  • 14
  • 24
20
votes
2 answers

How to do incremental backup every hour in Postgres?

Trying to do an hourly incremental backup of a single Postgres server (Win7 64). I have the following setup in postgresql.conf: max_wal_senders = 2 wal_level = archive archive_mode = on archive_command = 'copy "%p"…
Neil McGuigan
  • 8,653
  • 5
  • 42
  • 57
20
votes
4 answers

Where is my ORACLE_HOME Windows directory?

I'm trying to find my listener.ora file to edit it, but the docs say it's in the ORACLE_HOME directory, but where is that? I'm running 12.1.0 on Windows Server 2008
Jeff Puckett
  • 609
  • 2
  • 7
  • 15
19
votes
5 answers

Cannot open table mysql/innodb_index_stats

After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well. The errors I get in the mysql_error.log are: 2013-08-15…
Mike
  • 315
  • 1
  • 2
  • 7
18
votes
5 answers

How to disable annoying MySql update console

I have installed mysql 5.7, and from time to time (once per several days) it looks for updates (as I understand). Console window opens for several seconds, and then dissappear. It doesn't care, that I'm watching a movie in this time, and this…
Taras
  • 181
  • 1
  • 1
  • 3
18
votes
5 answers

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 try, I get "The database cluster initialization…
Larry Eitel
  • 281
  • 1
  • 2
  • 4
17
votes
5 answers

SQL Server is started but didn't listen on any port

I newly installed SQL Server 2012. No database created yet. And I can open the Management Studio with sa/password. The Binn\sqlservr.exe is started as a service and I can see it started in the service list. However, it didn't listening the 1433…
anaconda_wly
17
votes
2 answers

"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 computer 'FooDB' failed with the following error: "Access…
James Lupolt
  • 4,278
  • 5
  • 31
  • 46
17
votes
1 answer

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 reset the password for postgres in PostgreSQL on…
Jonas
  • 33,945
  • 27
  • 62
  • 64
15
votes
1 answer

Why would you use a managed service account rather than a virtual account in SQL Server 2012?

In SQL Server 2012, service accounts are created as virtual accounts (VAs), as described here, as opposed to managed service accounts (MSAs). The important differences I can see for these, based on the descriptions: MSAs are domain accounts, VAs…
jordanpg
  • 355
  • 5
  • 14
1
2 3
…
44 45