Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Friday, 12 June 2015

After Server Restarted Tempdb Added NDF file Would Exists or Not?

After Server Restarted Tempdb Added NDF file Would Exists or Not:

Suppose you have Tempdb 1 MDF ,1 LDF, 1 NDF  then  If you added 2 NDF file for performance Improvement Purpose then After Server Restarted would those Added NDF file Exist or not.

























After added Server Restarted as See below





but it is still exists 2 Added NDF file as see below