Thursday 10 May 2012

Find logical name and physical location of system databases using Sql Server


SELECT  name ,physical_name AS CurrentLocation ,state_desc FROM    sys.master_files WHERE   database_id = DB_ID(N'EasyShopAimsLab_new_1Mar2012')

No comments:

Post a Comment