The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
54 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 ...
0
votes
1answer
21 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
1answer
172 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 ...
-1
votes
1answer
416 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
0answers
32 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 ...
2
votes
0answers
115 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 ...
1
vote
0answers
51 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
0answers
401 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 ...
0
votes
0answers
20 views

Equalize datafile size

I have a DB 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. Different DB managers, forgotten autogrowth ...
0
votes
0answers
19 views

Tool for browsing JavaDB

I have bought a Java web based application which uses a JavaDB to store data. In the application files, there are 2 .db files named ff.h2.db and ff.trace.db where "FF" being the abbreviation of the ...
0
votes
0answers
127 views

SQL 2014 Database NDF file Lost - Filegroup offline

(Originally asked on StackOverflow and redirected here) I have a database that has lost one of its .ndf files and have been unable to get at the data. The ndf file in question was added last ...
0
votes
0answers
45 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
355 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 ...
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: ...
-2
votes
0answers
42 views

Data file NDF Vs MDF and performance overhead

We have database with multiple data files (*.ndf) and one of the data files we made to have static data tables i.e. not a transnational data (LibraryPrimary.ndf). Here is the load test result with ...