Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: files

mongodb wt file corrupt issue, can not query few documents

By adminPosted on November 15, 2022

Question : I have a mongodb cluster with 3 shards and no replication The problem is one of the shards […]

Mp3 file directly in a Database Without using BLOB [closed]

By adminPosted on November 2, 2022

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

Error 5123 when creating a database with my SQL Server on Linux [closed]

By adminPosted on August 1, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]

MariaDB CONNECT engine BIN table – file record layout, storage of a date data type, padding

By adminPosted on April 30, 2022

Question : In mariadb-10.4.5, running on Windows 10, I created this table (in the local database): `CREATE TABLE IF NOT […]

Copy database backup files from Azure to on-premise network

By adminPosted on April 30, 2022

Question : Goal – Take a database backup in Azure and copy the backup file(s) to company network for archiving. […]

Database with multiple .mdf files

By adminPosted on March 29, 2022

Question : I have searched online but not found what I am looking for. The problem/query is to my knowledge […]

How to check whether old MDF and LDF files are referenced

By adminPosted on January 5, 2022

Question : I inherited a setup, and I’m rather new with DB work. I’ve got a drive on my production […]

Data Files Outgrowing Hardware – Split the File?

By adminPosted on July 4, 2021

Question : Where I’m currently working, the primary business database is located on a virtual server (SQL Server 2005 standard). […]

Two SQL Server databases setup with same .mdf and .ldf files

By adminPosted on October 22, 2020

Question : In a SQL Server 2008 R2 instance two databases (the second one being a restore/copy of the first […]

how can I get mariadb tokudb to put all its files in directories per database

By adminPosted on June 22, 2020

Question : Is there a way to get tokudb to put all the files it creates for a database into […]

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding