All Questions
Tagged with datafile sql-server-2014
5 questions
-1
votes
1
answer
302
views
Move logship database file
I want to move a ldf file from one drive to another. Some idiot who is definitly not me restored the log file to the wrong drive which is nearly full now.
The database is readonly/standby for a ...
- 179
0
votes
1
answer
602
views
SQL Server data drive (.mdf files) running out of space
We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space.
A few weeks ago DB files were shrunk to temporarily ...
- 83
0
votes
1
answer
600
views
Unable to write to ndf after shrink emptyfile
I am doing some file balancing practice/experiments on AdventureWorks and pages stopped writing to the ndf file (AdventureWorks2014_Data2.ndf).
Early tests were working as expected. Proportional ...
- 6,318
0
votes
1
answer
772
views
Identify Full Text Catalog Files
I'm trying to write a query for a report to show how much free space is in our data files so we can plan storage for the future. I'm pulling data out of sys.database_files, and I can narrow it down to ...
- 3,272
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 ...
- 618