All Questions
Tagged with datafile sql-server-2008
7 questions
0
votes
1
answer
122
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 ...
- 2,101
0
votes
1
answer
756
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
1
answer
989
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,550
3
votes
1
answer
2k
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?
- 192
1
vote
1
answer
99
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 ...
- 5,785
1
vote
1
answer
407
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 2005/...
- 597
4
votes
6
answers
21k
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 ...
Mohamed Sawaf