| Author |
Topic |
|
mamad
Starting Member
4 Posts |
 Posted - 2008-02-15 : 12:54:24
|
| Hi I am trying to restore a remote database hosted on mysql server, using "SQL Server Management Studio Express".Now I can connect to the server, and see the databases as well. However, when I select restore option and want to specify the source using the Source for restore, and select From device, I can only select file from the remote machine, and don't get to select the file from my local file system. And the problem is that I don't have easy access to the machine hosting the MS sql server. So is there any way I can select my backup file from local machine. If this cannot be done using SQL Server Management Studio, can you please suggest other relates programs.I'd greatly appreciate any suggestion/info. Many thanks,ML. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-15 : 13:48:22
|
| I don't know whwther this is feasible for you, but have you considered Restored to your local machine and the IMPORT from remote.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
mamad
Starting Member
4 Posts |
Posted - 2008-02-15 : 15:57:05
|
| thanks for the comment ... so there is not direct way to do it using the management studio ... |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-15 : 16:46:38
|
| A restore command always runs in the context of the SQL Server, so it must be able to access the file either from the local file system or through a URL.CODO ERGO SUM |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:30:21
|
| You can do it with 'restore database' statement. |
|
|
|
mamad
Starting Member
4 Posts |
Posted - 2008-02-19 : 08:38:29
|
quote:
Originally posted by rmiao
You can do it with 'restore database' statement.
can you please elaborate more. So in restore database I specify a local file, and a remote database? I think I did give it a shot, but didn't get too far, but that could have been because I am not very fluent with command line of sql world. But if I know if this is doable I'll dig in more. Thanks. |
|
|
|
mamad
Starting Member
4 Posts |
Posted - 2008-02-19 : 09:43:21
|
quote:
Originally posted by Michael Valentine Jones
A restore command always runs in the context of the SQL Server, so it must be able to access the file either from the local file system or through a URL.CODO ERGO SUM
Thanks Michael, so I take it I can put the on http server, and provide the http url, or somehow, map a network drive in the remote sql server. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-19 : 11:01:14
|
quote:
Originally posted by mamad
quote:
Originally posted by Michael Valentine Jones
A restore command always runs in the context of the SQL Server, so it must be able to access the file either from the local file system or through a URL.CODO ERGO SUM
Thanks Michael, so I take it I can put the on http server, and provide the http url, or somehow, map a network drive in the remote sql server.
You will not be able to use a web (http) URL; it will have to be a reqular URL:\\SERVER_NAME\SHARE_NAME\DIR_NAME\BACKUP_NAME.BAKThe URL must be available to the SQL Server and the service account that SQL Server is running under must have access to it. It doesn't matter if you can connect to the URL from your computer, it only matters if the SQL Server can connect to it.CODO ERGO SUM |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:57:31
|
| It's unc name. |
|
|
|
|
Remotely restore a db using Management Studio