Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
sqllover2020's user avatar
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 ...
Greg's user avatar
  • 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 ...
Brandon's user avatar
  • 618