Knowing Physical file paths of database

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


USE DatabaseName
GO
EXEC sp_Helpfile
GO


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

Comments or Responses

Login to post response