2022 Developer Survey is open! Take survey.

Questions tagged [datafile]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4 votes
3 answers
873 views

How to recover from a SQL server log file drive crash?

Assuming data files are on D: and Log files are on E: Say the E drive crashes and the log files (.ldf) are lost. I attach a new empty disk to the E: and start the sql server. Upon startup, SQL Server ...
user avatar
  • 2,285
0 votes
0 answers
10 views

Split data file into multiple files

We have a 7 TB database that currently consists of 2 files (~2 TB & ~5 TB). We are also migrating onto a new platform and haven't yet decided on the migration method. It has been recommended that ...
user avatar
  • 1
0 votes
1 answer
56 views

Oracle 11gR2 (11.2.0.4.0) - Drop and Remove Datafiles

We have a database of 2000 users. We will drop all remaining schemas, leaving only 2 end users, excluding Internal (Oracle maintained) users. After this operation, there will be a very high reduction ...
user avatar
0 votes
1 answer
49 views

Production filesystem is at 100%. Move the datafiles to a new filesystem?

As the title states our file system reached 100% capacity and I want to try moving the tablespaces datafiles to a new filesystem. I'm attempting to follow the steps from this link: http://www.dba-...
user avatar
  • 11
0 votes
2 answers
96 views

Why is it not important whether data and log files share the same disk or not in a SAN? [closed]

I have a hard disk. I create 3 drives on it. One for OS. One for sql data files. One for sql log files. However I am reading that suppose my storage layer is not a hard disk, but a SAN based ...
user avatar
  • 2,285
0 votes
2 answers
46 views

Oracle: Corrupt datafile will not turn back online?

need immediate assistance on an issue... Oracle Support is taking way too long to respond back on. We have a corrupt datafile in one of our tablespaces, I attempted to shut the datafile offline, and ...
user avatar
  • 11
0 votes
2 answers
307 views

ORA-01652 - unable to extend TEMP segment?

Having an issue that I can't seem to find any solutions to online. [72000][1652] ORA-01652: unable to extend temp segment by 256 in tablespace TEMP Position: 581 One of our users runs a query ...
user avatar
  • 11
-1 votes
1 answer
105 views

Move logship database file

I want to move a ldf file from one drive to another. Some idiot who is definitly not me restored the log file to the wrong drive which is nearly full now. The database is readonly/standby for a ...
user avatar
0 votes
1 answer
123 views

SQL Server data drive (.mdf files) running out of space

We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space. A few weeks ago DB files were shrunk to temporarily ...
user avatar
0 votes
0 answers
62 views

How to open .bin SQL database?

I'm stuck and not sure if somebody had a similar issue. I have an old database stored as .bin files. It dates back to 2012. I can see an xml catalogue file which indicates to me that it is some kind ...
user avatar
0 votes
1 answer
17 views

how to restrict usage of datafile in Oracle

We have several datafiles with a big amount of a free space. How to shrink those files on production system. I tried to move all objects from this files into another tablespace, but RDBMS is still ...
user avatar
0 votes
1 answer
60 views

Postgres's equivalent for Oracle's datafile recovery

In oracle, one can do a recovery from datafiles. Does Postgres have an equivalent procedure? I am already aware of the WAL files in Postgres, but I believe this is different. Datafiles in Oracle are ...
user avatar
  • 321
1 vote
0 answers
31 views

Naming a datafile with spaces in the name

I would like to know if there could be a problem when naming a datafile with spaces in the name, I have an Oracle 11gR2 database, using ASM as storage, a datafile was created, belonging to an ...
user avatar
-1 votes
1 answer
69 views

unable to open database because of corrupt file

when ever i try to open my database i get an error saying SQL> alter database open; alter database open * ERROR at line 1: ORA-01147: SYSTEM tablespace file 13 is offline ORA-01110: data file 13: '/...
user avatar
1 vote
2 answers
786 views

SQL Database size incorrect and database file growing while empty

RESOLVED - SOLUTION AT BOTTOM OF POST PROBLEM I have a database data file showing as 200GB on disk, and 200GB allocated space in the database properties. sp_spaceused also shows 200GB allocated. All ...
user avatar
0 votes
0 answers
17 views

How to shutdown and startup a database to delete datafiles in between

OS: Windows 10 Professional / DBMS: Oracle 18c XE How would one approach the issue of losing a connection while shutting down the database? I would like to have one script which deletes datafilepaths ...
user avatar
0 votes
0 answers
140 views

SQL Server File or Filegroup Creation Date

Is there a way to find out when a File was added to a filegroup in SQL Server. Or how to determine when a filegroup was created? I've tried querying the sys tables looking at the lsn information and ...
user avatar
1 vote
1 answer
22 views

re size datafile oracle

thanks for reading. I am currently working with an Oracle 11G.I have a problem with a tablespace, I have very little space left, and I need to increase its capacity.I know what to do with this ...
user avatar
1 vote
1 answer
393 views

DBCC ShrinkFile EmptyFile fails due to system table SYSFILES1

In following a recommendation from our new storage vendor, I'm trying to split up some large & busy databases into multiple data files, each to live on a separate VDisk that has a separate ...
user avatar
  • 764
1 vote
1 answer
88 views

65G SQL Server database has 5.5G of data in tempdb when not in use

I have a SQL Server instance with 1 production database (also ReportServer dbs) that is 65G. tempdb is 5.5G (well, actually much bigger but 5.5G is in use) when server is not in use. I believe this ...
user avatar
0 votes
0 answers
121 views

Word file running an SQL command - How do I find the source SQL database?

A word 2013 file has a merge function that activates whenever this is open and it is "SELECT * FROM 'database'". As the final results have errors (the final word document feeds from the wrong field ...
user avatar
-1 votes
3 answers
8k views

Oracle data file size

My client’s tablespaces are autoextend off and i add monthly or bimonthly 3 or 6 gb space for tablespaces. Can you advise me if there is a recommended datafile size for Oracle 11gR2 on Windows 64 Bits?...
user avatar
0 votes
1 answer
155 views

Multiple mdf, empty one is missing

Hi guys i have a big problem. I know i did such stupid and unforgivable mistake. And know please help me if you can. I wanted to make copy of database. I should make it by backup and then restore as ...
user avatar
1 vote
1 answer
199 views

How to recreate Oracle db from .ora and .dbf?

I have a number of files left from a previous Oracle db and I would like to create a new one from the files. The files include: init_locdb.ora 16 .dbf files spfilelocdb.ora log files .ctl Could you ...
user avatar
0 votes
1 answer
117 views

Bulk Import appending the data to the data file

We have a bulk import task running in SQL Server 2016 which imports more than 5 million rows. The task itself is configured at cloud using third party services. The strange thing is that the new data ...
user avatar
  • 23
1 vote
0 answers
59 views

Transactional Replication and distribution database size

I have a transactional replication set up with initialize from backup. In the secondary database server,i have a drive(d:) for data files alone. I have noticed that this drive is getting filled and i ...
user avatar
  • 1,285
0 votes
1 answer
81 views

What is a good practice for storing unstructured tables as a field in mongodb

Context: I am developing an application that requires handling tables that do not necessarily have an uniform structure (eg. different/extra columns). Those unstructured files also need to be grouped ...
user avatar
  • 101
0 votes
2 answers
63 views

Considerable size difference between mysql versions

We usually employ different MySQL versions for different scenarios. And I realized that similar databases, whith the same amount of tables and data, just because of different mysql versions differs in ...
user avatar
1 vote
0 answers
323 views

MySQL 8 more than doubles the size of MyISAM table after optimization

I recently upgraded from MySQL 5.7 to 8.0. I have noticed some changes from 5.7 to 8. But I have not been able to find any discussion on following situation that I have been puzzling for a while. I ...
user avatar
1 vote
3 answers
813 views

Creating/restoring mdf/ldf to non-default file location giving access denied

Default folder is typical C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA. But C: drive on server is almost full. So, in restoring an 11gb database from another server, I ...
user avatar
0 votes
2 answers
314 views

Max DATAFILE size in NDB engine

My database setup is using NDB cluster with 2-3 nodes, on CentOS. While trying to test out the performance, i tried to store ~7mil records (around 2GB size) into one of the table. at around ~200k, it ...
user avatar
1 vote
2 answers
2k views

Migrating Postgres server from Windows to Linux

Simple question: I want to migrate all of a Postgres server's data, schema, roles, everything from Windows to Linux. Can I just copy the contents of the %PGDATA% directory in Windows to which the ...
user avatar
1 vote
1 answer
1k views

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
user avatar
  • 131
0 votes
0 answers
53 views

Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]

please can anyone help? I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile. I want to change this setup as per best practices by adding 3 additional euqally ...
user avatar
0 votes
2 answers
330 views

Moving DataFile to Another Location ORACLE

I'm having some problems moving DATAFILE from one location to another due to the shortage of storage space. I've managed to change the path file of control file via command(linux). Now I would like to ...
user avatar
2 votes
1 answer
81 views

How Database Formats Files for Disk

This SO answer outlines how MySQL organizes its database into files, but doesn't describe the structure of the files themselves. I am wondering, at the physical level, how relational database ...
user avatar
  • 209
1 vote
5 answers
7k views

TABLESPACE creation error

I have an error "ORA-01537" when I create a tablespace. create tablespace "VOLUMT" datafile 'VOLUMT.dbf' size 250M autoextend on; Then, it shows like following. ERROR at line 1: ORA-01537: cannot ...
user avatar
2 votes
1 answer
714 views

Disk Architecture on SQL Server [closed]

I am building a new environment using the SQL Server 2017 Always-On system. This will be active 24/7 and there will be lots of DML processes. I have a 100GB SAS for the OS, a 1TB SAS for Data and a ...
user avatar
  • 58
5 votes
1 answer
202 views

Difficulty removing files from filegroup

I am trying to delete all files from my database from an unused filegroup. There are two files totaling aroun 1.5TB. I can see that there is now approx 400mb still in these files but I cant see what ...
user avatar
2 votes
1 answer
275 views

SQL Server on Linux: Allocation unit on ext4

I'm testing SQL Server on Linux and now on the following point: Allocation Unit Size of the partition: I learned at SQL Server on Windows the Allocation Unit Size (sector size) must be 64K because of ...
user avatar
10 votes
2 answers
6k views

How to Move TempDB Files to a Different Drive or Folder? [duplicate]

How do I move my TempDB Data or Log File(s) from wherever they are now to a different Drive or Folder?
user avatar
  • 1,478
5 votes
2 answers
473 views

SQL Server: Identifying object closest to the end of a datafile

TL\DR I'm looking for a way to efficiently identify the object located closest to the end of a SQL Server data file. This approach needs to remain performant against large data files. What I have ...
user avatar
2 votes
2 answers
2k views

Backup and Restore SQL server files and filegroups

I have a database called Admin. It has only one default filegroup called primary. File group: primary files in the file group: Admin_data.mdf Now I have taken a full filegroup backup. Backup file ...
user avatar
  • 1,688
1 vote
2 answers
125 views

mysqldump file restore while sql is still being dumped

Im using MaridaDB 10, but my question applies to all mysql variants. I have large dataset (70GB uncomressed when dumped to file). The mysqldump process takes 2-3hours. The restore process takes even ...
user avatar
3 votes
1 answer
3k views

DBCC SHRINKFILE for Log and Data when using Availability Groups

We had an issue where one of our database tables grew by 40GB by mistake. The database is part of an Availability Group with one primary and two replicas. While trying to delete the extra records we ...
user avatar
  • 1,003
2 votes
1 answer
1k views

Mysql cannot import from text file

I have a table called person setup like this (person_id SMALLINT UNSIGNED, fname varchar(20), lname varchar(20), gender enum('M','F'), birth_date date, race enum('B','W','A','J'), ethnicity varchar (...
user avatar
  • 21
4 votes
1 answer
3k views

Two SQL Server databases share the same MDF and LDF files but have different data [closed]

I have a strange circumstance where I have a production database and a restored copy as another database on the same SQL Server instance, and both of them are using the same MDF and LDF files (i.e. ...
user avatar
  • 143
1 vote
1 answer
420 views

How to set a filesystem size limit for DB2 database? Is it possible?

I'm looking for a way to limit a DB2 database size (in disk) at creation time. But I couldn't find it. At SQL server we can do by this way: Create Database MyDatabase on (Name='MyDatabase_Data', ...
user avatar
0 votes
1 answer
5k views

In what situation the .NDF files are created?

I'm not a db administrator but from a quick search I found .NDF files are secondary data files. I'm curious to know under what conditions the .NDF files are generated ? If it is generated, how we can ...
user avatar
  • 105
4 votes
3 answers
5k views

Releasing free space in mdf file to OS [duplicate]

We have a 120GB database. There was table with 60GB of data which is useless and we have truncated it. Now database size is 120GB with free space 60GB. The database will not grow up to 60GB in at ...
user avatar