The datafile tag has no wiki summary.
5
votes
4answers
633 views
Do I really need to keep .LDF files?
Each month we make an end of month snapshot of our production databse. These month end snapshots are strictly for reporting purposes, there are no inserts, updates or deletes ever done on them. Each ...
3
votes
2answers
69 views
Autogrow. Primary vs additional data files
My databases all use autogrow, which grows the primary MDF file on a percentage. But one of the databases, from a third party application grows by adding additional .NDF files.
Where is this option ...
3
votes
2answers
100 views
Disk space full but logical space available in database
We have a fairly big MS SQL 2008R2 database that resides on a SSD drive. The drive itself only has ~110Gb of space, and the database files are the only files on the drive.
The database is in "Simple" ...
3
votes
2answers
448 views
Shrinking the SYSTEM tablespace in Oracle
Our SYSTEM tablespace grew out of control because of the SYS.AUD$ table.
We have truncated SYS.AUD$ but the datafile is still very big (~30G).
Resize doesn't work because the file contains used data ...
2
votes
6answers
468 views
SQL Server split mdf into multiple files
I have a database called example.mdf with a total size of 1GB which suffers from performance issues. I checked the allocated hardware and it is higher than required, I double checked the design and ...
2
votes
1answer
100 views
Identify File Growth Events
I'm discovering a number of DBs in my portfolio that have been created with default autogrow settings (either 1 MB or 10% increments) that have expanded for an extended period of time. If I wanted to ...
2
votes
1answer
192 views
Restore InnoDB tables / database using only data files
I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine.
I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
2
votes
1answer
59 views
Adding specific information to a local file
I have several files on a webserver (not stored in the database). I'd like to store several information to this specific file. The user should be able to post comments about this file.
My question ...
1
vote
4answers
802 views
What's better/faster? MySql or FileSystem?
Let's imagine a web site that is a directory of people. For each person there may be a profile photo and a biography.
I'll admit my SQL queries could be better but in general what would be faster and ...
1
vote
2answers
55 views
Oracle datafile extension .dat or .dbf
I have seen these 2 extensions used for datafiles, .dat and .dbf while creating and/or altering a tablespace. I'm not sure what the difference between the 2 extensions is, or if .dat is incorrect.
...
1
vote
1answer
283 views
Are multiple dbf files better than one?
Is it better to distribute a large database over several dbf files than over a single one?
1
vote
1answer
110 views
file not found - how to remove its configuration?
I run oracle 10.2.0.5.
I have the following:
SQL> select file#, status, error, recover, tablespace_name, name
2 from v$datafile_header
3 where recover='YES'
4 or (RECOVER IS NULL AND ...
1
vote
1answer
489 views
How many files should I create for one filegroup and 9 weekly partitions?
I have 9 weekly partitions on one filegroup. How many files do I need to create?
There are 3 tables containing 46 million, 16 million and 10 million rows.
0
votes
1answer
49 views
Should database files be on different disk(s) than OS?
My very short overview
SQL Server databases are installed as virtual machines on VMWare, there are plugged a few disk areas with the same (or very similair) parameters
versions are SQL Server ...
0
votes
1answer
384 views
Save output from multiple SQL SELECT commands to a file
Within a Postgres function I would like to run a number of SQL SELECT commands and append the output to the same variable. After all the SELECT commands have run this output should be written to a ...
