Questions tagged [datafile]
The datafile tag has no usage guidance.
142 questions
0
votes
2
answers
45
views
SQL Server: which data file extension should be used when adding a primary file on another drive?
If I have a Windows disk with a capacity of 1T, for example, and the primary datafile (.mdf) for my database reaches the disk's maximum size, I want to add a second datafile to the primary group.
As ...
- 1
1
vote
1
answer
101
views
SQL Server Express mdf file is 50+gb
I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run select @@version I get:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:...
-2
votes
1
answer
40
views
How to modify filepath of a database file that is inside a file group [duplicate]
How do you modify filepath of a database file that is inside a filegroup?
Just the normal and direct way?
Alter database []
Modify file (name='', newfilepath='')
Or
Alter database []
Modify filegroup ...
0
votes
0
answers
40
views
Does adding a new data file (without partitioning) have any pro/con compared to increasing space on existing data file?
I have a database data file with 1 data file in the default filegroup. It is reaching to 500GB in size and I'm trying to learn about whether to increase the size of existing data file or add a new ...
- 3,489
1
vote
1
answer
20
views
In MS Studio how to SELECT from an existing SQL file
I have a complicated query that select parts from an MRP table using several different criteria. The output of the query is a list of parts which includes the key field [PartNum]. I have saved this ...
- 11
1
vote
1
answer
520
views
Database file reserved space
What are the possible reasons that a SQL Server database file reserved space is 95 percent of the total space? My database file has increased drastically and it shows that the actual space used is 5 ...
-1
votes
1
answer
352
views
How to load data into a table from a file and set other column(s) too?
I have a table with multiple columns. And there's also a text file which contains data, one value per line:
aaa
bbb
ccc
ddd
How would I load a file into a file into a certain column as well as set ...
- 45
0
votes
1
answer
47
views
Can database administrators access and modify the database before it's opened?
I'm trying to answer the following question (asked in a previous exam and supposedly having one correct answer):
To create a DATAFILE and Assign it to a DATABASE, the instance can't be
started in ...
- 131
1
vote
1
answer
169
views
InnoDB - how MySQL InnoDB pages works with underlying OS file system
I've studied and summarized how MySQL InnoDB pages works with underlying OS file system when accessing secondary storage.
Would you mind to confirm that my understanding is correct?
InnoDB store ...
- 113
0
votes
1
answer
1k
views
Change default location for Oracle datafiles
I wanted to change the default location for Oracle datafiles and spread data across different physical drives using below command. This way u02, u03, u04, u05, ... will automatically point to ...
- 3
0
votes
1
answer
539
views
Oracle Data Guard - Wrong Path with new created Data Files
I've created a Standby Database with the following duplicate command:
run {
duplicate target database for standby from active database
spfile
parameter_value_convert 'ORCL','ORCLSTBY'
set db_name='...
- 3
4
votes
3
answers
2k
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 ...
- 3,489
0
votes
1
answer
259
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 ...
- 29
0
votes
1
answer
73
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-...
- 11
0
votes
2
answers
970
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 ...
- 3,489
0
votes
2
answers
188
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 ...
- 11
0
votes
2
answers
2k
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 ...
- 11
-1
votes
1
answer
302
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 ...
- 179
0
votes
1
answer
602
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 ...
- 83
0
votes
0
answers
344
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 ...
- 1
0
votes
1
answer
33
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 ...
- 430
0
votes
1
answer
213
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 ...
- 331
1
vote
0
answers
125
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 ...
- 169
-1
votes
1
answer
325
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: '/...
2
votes
2
answers
4k
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 ...
0
votes
0
answers
489
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 ...
1
vote
1
answer
28
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 ...
- 125
2
votes
1
answer
2k
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 ...
- 804
1
vote
1
answer
136
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 ...
- 11
0
votes
0
answers
884
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 ...
- 13
-1
votes
3
answers
13k
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?...
0
votes
1
answer
273
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 ...
1
vote
1
answer
350
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 ...
Pavel
0
votes
1
answer
168
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 ...
- 23
1
vote
0
answers
132
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 ...
- 1,335
0
votes
1
answer
116
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 ...
- 101
0
votes
2
answers
144
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 ...
1
vote
0
answers
479
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 ...
- 21
3
votes
3
answers
2k
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 ...
- 131
0
votes
2
answers
457
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 ...
- 13
1
vote
2
answers
3k
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 ...
- 354
1
vote
1
answer
2k
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 ...
- 131
0
votes
0
answers
56
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 ...
- 39
1
vote
2
answers
2k
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 ...
- 19
2
votes
1
answer
106
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 ...
- 221
1
vote
5
answers
10k
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 ...
- 97
2
votes
1
answer
1k
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 ...
- 58
5
votes
1
answer
243
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 ...
- 189
2
votes
1
answer
361
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 ...
- 33
11
votes
2
answers
11k
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?
- 1,554