Questions tagged [datafile]
The datafile tag has no usage guidance.
142
questions
0
votes
0
answers
49
views
SQL Server Express mdf file is 50+gb
Good day,
I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run the select @@version I get the following:
Microsoft SQL Server 2017 (RTM) - 14.0.1000....
-2
votes
1
answer
36
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
39
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,476
1
vote
1
answer
19
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
264
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 ...
0
votes
0
answers
19
views
Restoring PDBs on a new server
I am trying to restore a 19c database on a new server using RMAN. What are the prerequisites? Do I have to first create PDBs which are supposed to be restored? Or should I just restore from ...
-1
votes
1
answer
225
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
44
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
148
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
458
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,476
0
votes
1
answer
245
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
64
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
871
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,476