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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Index file

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -