Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-03-31 : 10:20:47
|
| Hi,what happens to database if I delete a index file?I have sql 2008 database with 1 mdf and 1 ndf and 2 index files in different drives and a log file.If I delete the 1 Index file? does database become inaccessible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-31 : 13:12:49
|
| Why would you delete it? Aren't there indexes on there? Is the file empty?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-03-31 : 18:11:19
|
Why How would you delete it? Aren't there indexes in there?===============================================================================“Everyone wants a better life: very few of us want to be better people.” -Alain de Botton |
|
|
|
|
|
|
Index file