Post reply

how get how many files(mdf.ldf,ndf) are there in database backup file .bak

  • July 9, 2009 at 6:41 am

    #133742

    Hi ,

    If i have the backup and dont know how many files are there is database backup like mdf ,ndf,ldf,

    how can i get the information from my backuup file .bak

    thanks in advance

  • July 9, 2009 at 6:49 am

    #1022315

    Try running this command where is the path (without the angle brackets but possibly double quoutes if there are spaces in any of the directory names) to your backup file:

    RESTORE FILELISTONLY FROM

  • July 9, 2009 at 6:49 am

    #1022316

    restore filelistonly from disk='backup file name'

    see BOL for details


    Pradeep Singh

  • July 9, 2009 at 6:51 am

    #1022317

    hi,

    you can use this syntax to view the file backup information

    RESTORE FILELISTONLY FROM DISK = N'C:\restore\restore.bak'

    if you need more info you can use those syntax

    RESTORE HEADERONLY FROM DISK = N'C:\restore\restore.bak'

    RESTORE LABELONLY FROM DISK = N'C:\restore\restore.bak'

    RESTORE VERIFYONLY FROM DISK = N'C:\restore\restore.bak'

Viewing 4 posts - 1 through 4 (of 4 total)

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