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
 General SQL Server Forums
 New to SQL Server Programming
 Remote Restore without Enterprise Manager

Author  Topic 

gp_330
Starting Member

6 Posts

Posted - 2005-10-07 : 03:46:08
Hi guys, I don't own a copy of Enterprise Manager and I need to remotely restore a database on my local machine to my hosted machine, can you guys recommend an application that can do remote restores?

Or is there a way to convert a Database into a long set of Transact SQL statements that I can run on the remote server (ala MySQL's MySQLDump)?

Thanks
GP

Kristen
Test

22859 Posts

Posted - 2005-10-07 : 05:39:39
You could use the RESTORE command - syntax example is here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300

Kristen
Go to Top of Page
   

- Advertisement -