SQL Server Performance

File & File Group Restore .

Discussion in 'SQL Server Log Shipping' started by sourav_tech, Mar 19, 2007.

  1. sourav_tech New Member

    Hello Freinds,
    I want to know about the query to perform the File & File group restore operation with some advance options like it will show to the user that some % of data has been backed & so on..

    Reply me soon...

    Thanks & Regards,

    Sourav Mukherjee
  2. Luis Martin Moderator

    As far I know there is no query to show % of data been backed.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. thomas New Member

    Look at the WITH STATS clause of the RESTORE statement, that gives you progress in the %age increments you specify.

Share This Page