Post reply

Database File Path to Directory

  • January 28, 2008 at 4:32 am

    #181264

    Hi All,

    Can any one tell me how can i get info for database files location. as i know that if i use

    select * from sys.files. it's give me the acutally phiysical location of the file but i just need the path only.

    what sys.files give me :

    C:\data\x.mdf.

    but i m only looking for

    C:\data\

    Thanks and looking forward.

    -MALIK

  • January 28, 2008 at 5:10 am

    #772346

    Try this out

    select Left(filename, len(filename)-charindex('\',reverse(filename))+1) from [sysfiles]

    HTH

  • January 28, 2008 at 5:13 am

    #772349

    thanks. it's working now

  • January 28, 2008 at 5:16 am

    #772350

    welcome 🙂

  • January 28, 2008 at 5:18 am

    #772352

    if u dont' mind can i ask one more question.

    is there any code or script that can be used to create a copy of Database with new name and location.

    i dont' know the way i m doing is professional. what i do, i just take the back of the database which i want to use to create a new database and then restore as new name and locations.

    if you have better idea , please let me know. Acutally i m looking for script or procuder that can do this.

    Thanks and looking forward.

    -MALIK

  • January 28, 2008 at 5:23 am

    #772355

    whatever you are doing is correct, this is manual way of restoring the database with new name. Also you can write a stored procedure with two input parameters as DBName and location and inside the procedure just write the restore DB script.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply