Post reply

Database Backup Restore

  • June 25, 2013 at 10:15 pm

    #274486

    Comments posted to this topic are about the item Database Backup Restore

    Best,
    Naseer Ahmad
    SQL Server DBA

  • June 25, 2013 at 10:17 pm

    #1627363

    Nice question. I have never used this option. Good to know!

  • June 25, 2013 at 11:39 pm

    #1627372

    I have taken "TestPartition" Database backup (In that db , 5 table are partitioned with 10 file-groups(.ndf files)) then I executed below command

    RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'

    It is showing only mdf and ldf files, It is not showing partitioned secondary file-groups(.ndf files)

    Is there any option to see .ndf files?

  • June 26, 2013 at 12:04 am

    #1627375

    Few months ago, i posted same kind of question.

    It good to recall it. Thanks 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • June 26, 2013 at 12:31 am

    #1627383

    KWymore (6/25/2013)

    Nice question. I have never used this option. Good to know!

    +1 🙂

    ~ Lokesh Vij

    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • June 26, 2013 at 1:02 am

    #1627392

    KWymore (6/25/2013)

    Nice question. I have never used this option. Good to know!

    +1 🙂

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • June 26, 2013 at 2:09 am

    #1627414

    Nice back to basics question - thanks

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • June 26, 2013 at 2:24 am

    #1627422

    PRR.DB (6/25/2013)

    I have taken "TestPartition" Database backup (In that db , 5 table are partitioned with 10 file-groups(.ndf files)) then I executed below command

    RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'

    It is showing only mdf and ldf files, It is not showing partitioned secondary file-groups(.ndf files)

    Is there any option to see .ndf files?

    I was unable to replicate this.

    I created a new database with three files (primary, log, and one secondary), backed it up, then checked the output from FILELISTONLY - all three files were there.

    I'll try a few more things, but maybe you can help by posting the CREATE DDL used to create your "TestPartition" database?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • June 26, 2013 at 5:39 am

    #1627489

    nice question 🙂

  • June 26, 2013 at 5:43 am

    #1627491

    Too easy 🙂 I am amazed how 32% people doesn't know this.

    Probably they are always using the "Restore Database Wizard" from SSMS, where SSMS does this all for them. Another reason why one should not do all the DBA tasks from SSMS, but try to do it with T-SQL.

    Sujeet Singh

  • June 26, 2013 at 5:53 am

    #1627497

    I misread the syntax and got it wrong. It happens.

    Thanks for the learning opportunity.

  • June 26, 2013 at 6:11 am

    #1627509

    Good question!!!

  • June 26, 2013 at 6:53 am

    #1627525

    Hugo Kornelis (6/26/2013)

    PRR.DB (6/25/2013)

    I have taken "TestPartition" Database backup (In that db , 5 table are partitioned with 10 file-groups(.ndf files)) then I executed below command

    RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'

    It is showing only mdf and ldf files, It is not showing partitioned secondary file-groups(.ndf files)

    Is there any option to see .ndf files?

    I was unable to replicate this.

    I created a new database with three files (primary, log, and one secondary), backed it up, then checked the output from FILELISTONLY - all three files were there.

    I'll try a few more things, but maybe you can help by posting the CREATE DDL used to create your "TestPartition" database?

    post the backup command as well, maybe you did a filegroup backup.

    ---------------------------------------------------------------------

  • June 26, 2013 at 8:13 am

    #1627578

    I came really close to misreading the syntax and saying none were correct.

    I do use the tools that are given to me by SSMS. There is a reason they are there. Of course since our primary databases doesn't actually get backed up in the traditional sense I don't get to use Restore in a time when speed is of the essence.

  • June 27, 2013 at 2:45 am

    #1627854

    Nice to know this...thnx

Viewing 15 posts - 1 through 15 (of 24 total)

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