Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 restore to remote server

Author  Topic 

sumanshakya
Starting Member

1 Post

Posted - 2007-09-04 : 03:11:58
hi everyone,
i need to restore database to remote server using SSIS. Can anyone tell me how can i do this or point to some articles for this.

Suman

SumanShakya

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-04 : 22:55:35
Why restore db with ssis? You can do it simply with 'restore database' statement.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-09-05 : 03:49:08
If you need some help with the syntax of RESTORE statement see here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example
Go to Top of Page
   

- Advertisement -