The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
16 views

I want to make a website similar to Udacity, Coursera e.t.c. for online courses. Which technology should I use for storing the course information? [on hold]

I am mainly confused between storing the information of a certain course in an SQL Database A JSON / XML file for each course which will then be stored in a file storage system and can be retrieved ...
1
vote
2answers
22 views

Different services using different port pointing to same datadir folder

Let say I have already installed service MySQLa with mysqla.ini (port number=3306) setting and datadir folder in ...\data Is it possible then, I install another service MySQLb with mysqlb.ini (port ...
0
votes
1answer
35 views

How can I delete a file from the primary filegroup?

In dealing with fragmented disk space, I added a second data file to one of my databases. Most of the data is now in the the second file, and I'd like to drop the first to simplify things. However, ...
0
votes
2answers
42 views

SQL Server Storage for multiple data files

Recently, our company wants to add 4TB on the drive size for SQL Server. We have two drives now which have different size and data files. In order to make sure our SQL Server has the best performance, ...
0
votes
1answer
37 views

Deadlock resource when try to drop datafile

This morning I did a mistake, I made a datafile offline by using alter tablespace users drop datafile 'C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_6LD56LRR_.DBF'; The reason is I want to drop that ...
3
votes
1answer
34 views

how to change the file directory of your log and data files and what are the effects

I have inherited a SQL server 2012 instance where the file directories of the log and data files are on the same folder on the same drive(all are in the C:\ drive). My task that I will be doing is ...
4
votes
1answer
38 views

Howto query all files, their fill level and additional drive info with one query?

I need a query that puts together the following results: one row per databse file across all databases additional columns with information about the locigal drive the file is on information about ...
0
votes
0answers
56 views

Drop Datafile and Reuse the Tablespace - Oracle

Oracle 12C is my database. I was moving the datafile from one directory to another directory by making the tablespace Offline. ALTER TABLESPACE TABLESPACE_NAME OFFLINE NORMAL; But accidently, while ...
0
votes
1answer
174 views

ORA-01122: database file 5 failed verification check

Oracle version: 11g r2 OS: win server 2008 SQL> alter database open; alter database open * ERROR at line 1: ORA-01122: database file 5 failed verification check ORA-01110: ...
0
votes
0answers
36 views

why database fill only one datafile of tablespace?

database tablespaces give error mail to me. It says TABLEINDEX haf %2 free size. But I looked, only 5.th datafile filled %85 and others are not filled (%0 or %1) all datafiles are 32 GB. I send photo. ...
1
vote
1answer
35 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, ...
0
votes
0answers
71 views

Equalize datafile size

I have a DB (Microsoft SQL server 2008 R2 (10.50.1600.1)) that has 28 datafiles with all different filesize. Some are 10GB, some 15GB, some 27 GB, etc. The difference in filesize is a historical fact. ...
5
votes
1answer
54 views

Why isn't transaction log free space always reused?

After monitoring the Transaction log files for a while I noticed that some of them sometimes behave in a way I did not expect. Here are two samples for comparison. All data is based on EXEC('DBCC ...
1
vote
2answers
25 views

How to get readonly access to mysql files via g+w permission 750 or 640?

The data-dir itself has permissions 700 thereby limiting access to the mysql user. I want other folks who I add to the mysql group to be able to read binlogs and download the *.frm, *.MYI, *.MYD ...
1
vote
1answer
271 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
1answer
95 views

Post data deploy in SSDT

I need to create post deployment script which will upload data from .csv file to my database. But I can't understand how can I do this. When I tried to deploy my project on my server I receive this ...
1
vote
1answer
249 views

Reclaiming unused space from datafile in oracle

Tablespace Used MB Free MB Total MB ------------------------------ ---------- ---------- ---------- DATA_S1 686 295 981 We ...
-1
votes
0answers
35 views

Unable to start Oracle database [duplicate]

I have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
0
votes
1answer
27 views

Filter Data to different data files on SQL server

I'm sure this is possible but I have no idea how or where to find the information on how to do it. Scenario: I have a reporting database (on SQL2008R2) which is split up into multiple file groups ...
0
votes
2answers
501 views

Drop datafile without dropping a tablespace in Oracle 11g

I was trying to take backup of database in Oracle 11g by using RMAN $ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 11 10:14:37 2015 Copyright (c) 1982, ...
0
votes
1answer
771 views

How to copy tablespace from one database to another database in Oracle 11g

How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?
2
votes
0answers
155 views

SQL Server 2008 R2 - Two Files Stuck In Restoring Status

Background: SQL Server 2008 R2 mirrored and clustered. We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
2
votes
1answer
45 views

Pausing the import of an SQL file in Postgresql?

I am currently importing a large database (6 - 7 GB's) into my postgresql on Ubuntu. It's taking sometime to do. A problem has come up where I need to physically relocate the laptop the postgresql is ...
0
votes
2answers
402 views

Clipper / DBF error

I'm not able to open a Clipper application (the app is 15 years old) because I'm getting : error dbfntx/1012 corruption detected Is there anyway to fix corrupted dbf files besides restoring from the ...
0
votes
1answer
29 views

Instant File Initialisation on Windows Oracle Server

I require to add additional datafiles to a SmallFile tablespace. The process took several minutes on my system for 1 datafile. Is it possible to allow Oracle the same capability as SQL Server using ...
0
votes
1answer
255 views

LDF files vs. TRN files vs. Tempdb.MDF+LDF files.:

We have a dilemma… We have all of our MDF and LDF files in the same…\192.168.6.22\d$\Program Files\Microsoft SQL Server\DATA\Production...folder. We have all of our TRN and BAK files on the…\192.168.6....
5
votes
1answer
150 views

Find what data is placed in a datafile

I have a database with 5 .ndf (secondary) datafiles on SQL Server 2008 R2. (Each of these datafiles is assigned to a separate filegroup.) I want to know what data is there in those files. Is it ...
1
vote
4answers
506 views

Script to merge-replicate two MDF database files?

I have a program on a computer and on a tablet. The program uses SQL Server Express to interact with a local database (the same information on both) from a .MDF file. So if I plug the tablet into the ...
0
votes
0answers
55 views

Database still reports 600GB after removing 500GB File

I have a database with three files Log Primary Data File Blob Data file the database was becoming too big to manage (600GB) so we removed the blob data (500GB) into FileStorage outside the DB. ...
0
votes
0answers
619 views

How to find out the maximum number of datafiles per tablespace in Oracle?

According to this Oracle document, the maximum number of database files per tablespace is "Operating system dependent; usually 1022". I know there are queries for some of the other limits mentioned ...
1
vote
1answer
129 views

MySQL Data Files Missing?

We are upgrading our website and I was checking on the size of the new database compared to the old one and was really surprised to find that in the /var/lib/mysql/ directory, the only files there ...
3
votes
1answer
201 views

Difference in space used

When reviewing the space used by datafiles in SQL Server, there is a large difference betweens what SQL reports and Windows. How can this be explained?
2
votes
1answer
57 views

Database Size Troubleshooting

I have a SQL Server database and the .MDF file is almost 9GB in size. However, the data and indexes only seem to be taking up a little over 1GB. I've shrunk the database (with and without ...
4
votes
3answers
13k views

How to export an image column to files in SQL Server?

I will migrate from a database. There is one column of type image that I would like to export to binary files on the file system. One file for each record. How can I do this with SQL Server?
2
votes
2answers
977 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 ...
5
votes
2answers
7k views

Removing secondary data files. DBCC SHRINKFILE: Page could not be moved because it is a work table page

I have too many secondary data files (.ndf) created for tempdb. To remove the excess files, I need to empty the file (content will be moved to other files): DBCC SHRINKFILE('tempdbfile8', EMPTYFILE); ...
2
votes
1answer
135 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,...
3
votes
1answer
491 views

MariaDB ALTER TABLE produced a separate .ibd file, how can I re-integrate the data into the shared table space?

We have a multi-GB InnoDB MariaDB (recently switched from MySQL). For some reason, the value of innodb_file_per_table changed to ON (we wanted only one innodb data file explicitely). So when I ran an ...
-1
votes
1answer
549 views

Disable MongoDB journaling?

Are there any benefits in disabling mongodb journaling besides performance gain? I know journaling provides write durability and crash resiliency. But I can tune syncdelay parameter to make data files ...
4
votes
1answer
638 views

Repair SQL Server Database [closed]

Can anyone give me a complete guide to verifying/repairing a SQL Server database? At the moment our backup is failing on the Solarwinds database saying the database NetPerfMon is corrupted (we are ...
1
vote
1answer
381 views

How can I set block size on Oracle 11 when creating a database instance

Is there any way to configure Oracle 11g's default block size on installation? I have tried Oracle 11g r2 and r3, during both installations block size is 8k and it is disabled (and can not be modified)...
0
votes
0answers
1k views

I'm unable to open a datafile in oracle, looking for a solution

I'm trying add more data into my schema, but I encounter the following error ORA-01116: error in opening database file 14 ORA-01110: data file 14: '/u01/oracle/oradata/REVA/ra_tbsp07.dbf' ORA-27041: ...
0
votes
2answers
315 views

Discover the original OS of a datafile from a oracle backup

I have just been awarded with the task of recovering a oracle database with some given datafiles. However, nobody knows from which OS this backup comes from. I have an AIX box to make the recover. Is ...
2
votes
2answers
709 views

where is the index physically located in MySQL database

Just wondering where is the index info physically located in MySQL database if I have indexed a table with ALTER TABLE contacts ADD KEY (columnName); ? it will stay with that table and add a new ...
1
vote
0answers
52 views

Is there a program I can use to redistribute DB files across multiple volumes efficiently?

I'm working with a VLDB instance with over 60 DBs and close to 200 DB files, allocated over nearly 20 volumes. The instance is a Dev server getting periodic restores from a production instance with a ...
1
vote
1answer
2k views

RMAN rename datafile created in an archivelog

I'm trying to restore an Oracle database (11.2.0.4.0) to a test system with a different file layout. The production database is being backed up using RMAN, no catalog. We do a full backup of all the ...
3
votes
1answer
616 views

Tempdb data file disappearing

I recently moved my Temp database files onto a separate drive (I had two data files and one log file). However, after restarting the server, my second data file disappeared both from the file list on ...
0
votes
1answer
899 views

MySQL warnings while loading integer data into table (SOLVED)

For some reason, after loading a large amount of data into the following table (from a single file), all of the values register as 0. CREATE TABLE secondTable ( freq int NULL, w1 int NULL, w2 int ...
1
vote
1answer
82 views

1 time shrink of abused databse or restore from backup [duplicate]

I have a database that I have inherited which has been left for a long time to grow and grow. 95% of this growth is caused by 1 log table used by our application. The database is 120GB and in full ...
0
votes
0answers
470 views

load_file() doesn't work but load data local infile works

I'm trying to load a non-regular file with MySQL: select load_file ('/proc/cmdline') It returns NULL So I checked the documents here, the file is readable, because as mysql user, I can execute ...