Post reply

Filegroup backup/restore using litespeed.

  • May 11, 2011 at 7:27 am

    #389501

    I am trying to do filegroup backup and restore using litespeed. Filegroup backup worked but when tried to restore, filegroup was offlline. To resolve this, I did transaction log backup of database and restore. Filegroup came online. But issue is it didn't restore the table which was on this filegroup.

    I am using following command for filegroup backup and restore. Is it correct ?

    Backup:

    EXEC master.dbo.xp_backup_database @database='MyDB'

    , @filename= 'C:\MSSQL\Backup\MyDB_Backup.BAK'

    , @filegroup = 'PRIMARY'

    , @init= 1

    Resrore:

    EXEC master.dbo.xp_restore_database @database='MyDB'

    , @filename = 'C:\MSSQL\Backup\MyDB_Backup.BAK'

    , @with = 'MOVE "MyDB_Data" TO "C:\MSSQL\Data\MyDB_Data.MDF"'

    , @with = 'MOVE "MyDB_log" TO "C:\MSSQL\Data\MyDB_Log.LDF"'

  • May 12, 2011 at 12:15 am

    #1323488

    What is the physical design of database MYDB?

    For file/filegroup backup both table and indexes should be on the same drive. If not both the filegropu must be backed up together. Refer the folloing MS article.

    http://msdn.microsoft.com/en-us/library/aa178589(v=sql.80).aspx

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • May 12, 2011 at 9:59 am

    #1323784

    I created one table on filegroup. And tried backup and restore for this file group. There is no index on this table.

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

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