Knowing Physical file paths of database

Posted by Bandi under Sql Server category on | Points: 40 | Views : 225
sp_Helpfile helps you to retrieve physical path of database files where the .mdf and .ldf files resides..

USE DatabaseName
EXEC sp_Helpfile

returns current database' physical storage paths alsong with maxsize and used space detials

Comments or Responses

Login to post response