Post reply

Initiate a retore of xyz.bak from SSIS

  • March 17, 2009 at 9:17 am

    #219167

    I have a process that retrieves a zip file from a FTP site, it unzip's the file, now I need to initiate a restore of a database. Can someone help me with this?

    Thanks,

    Jeff

  • March 17, 2009 at 9:19 am

    #961144

    have it unzip it to a defined location and name them write a SQL command restore

    Restore ....

    Then put that in as a SQL task or define it with an OSQL task in a bat job and call that.

  • March 17, 2009 at 9:24 am

    #961149

    The zip file will always be extracted to the following:

    c:\RealPage_FTP\U1050266.bak

    I'm good with SQL from a data perspective, but not on the admin side. How would I write a SQL statement to restore this file over the existing database 'RealPage'?

    thanks,

    Jeff

  • March 17, 2009 at 9:29 am

    #961154

    I went through the steps of the restore, but instead of executing, I scripted it.

    Does this correct?

    RESTORE DATABASE [RealPage]

    FROM DISK = N'C:\RealPage_FTP\U1050266.bak'

    WITH FILE = 1

    ,NOUNLOAD

    ,STATS = 10

    GO

  • March 17, 2009 at 9:29 am

    #961155

    The quickest way would be to do it from Mgmt Studio and instead of clicking ok use the script option to script it out.

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

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