Post reply

What's the fatest way to restore? SSIS

  • January 30, 2014 at 9:48 am

    #281806

    Hi,

    Long story, but I'm restoring a remote SQL DB via SSIS. I'm using this inside a 'Execute SQL task':

    DECLARE @Ext nvarchar(3)= N'bak'

    DECLARE @FileName nvarchar(256) = N'H:\MovedBakFiles\ULTIPRO_WSI\Ultipro_WSI.'+@Ext

    RESTORE DATABASE [Ultipro_WSI] FROM DISK = @FileName WITH FILE = 1,

    NOUNLOAD, REPLACE, STATS = 10

    GO

    This works, but takes forever. Is there any way to achieve a faster restore?

  • January 30, 2014 at 10:14 pm

    #1684922

    What do you mean by takes forever? I guess very very slow?

    howmuch is the size of the database? Try restore using creating job and check? What are the other activity going on the server while restore? Does restore T-sql from Query editor execute faster?

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

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

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