Questions tagged [datafile]
The datafile tag has no usage guidance.
11
questions
57
votes
6
answers
214k
views
How to insert (file) data into a PostgreSQL bytea column?
This question is not about bytea v. oid v. blobs v. large objects, etc.
I have a table containing a primary key integer field and a bytea field. I'd like to enter data into the bytea field. This ...
5
votes
2
answers
14k
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" ...
2
votes
1
answer
630
views
How does subpartitioning actually work and what physical files are created?
I can't understand how the subpartitioning works in mysql.
I am reading the following example:
create table invoices (
customer_id int not null,
product_id int not null,
amount decimal (8,...
11
votes
2
answers
10k
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?
9
votes
1
answer
18k
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 ...
3
votes
1
answer
706
views
cleaning up failed repair db: path: /var/lib/docker/wesfgr/repair/_tmp_repairDatabase_0
We run MongoDB 3.0.6 with MMAP in Docker container (single node). The filesystem was full and I did a repair with other path.
2016-10-03T08:58:51.186+0200 I INDEX [initandlisten] building ...
1
vote
2
answers
3k
views
Detached database file permissions
I have a script that detaches databases for archival when they meet certain criteria. The script is executed by SSIS under the local Administrator account by the Ghost of DBA Past. Per design it (by ...
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 ...
1
vote
1
answer
7k
views
'Logical file name "MyDB" is already in use' Even though the database doesn't exist [closed]
I recently was given a SAN with a couple of RAID arrays to apply to my database server to increase performance. I have (and will only ever have) one user database called DDAS, in addition to the ...
1
vote
2
answers
2k
views
Storing blobs outside the database
I had a PostgreSQL database with loads of scanned documents, as a document bytea column in the table scans, with hundreds of thousands of documents that was large and inconvenient to backup. Also, ...
-9
votes
2
answers
3k
views
Wrong Last Modified Date of .ndf file on SQL Server
I have SQL Server Database and we have many tables. To improve performance, I have created different filegroups with files on different disks just for indexes. I have created new index today in a ...