Copy database from remote server to local?

19 Apr 2006 8:02 AM

Noozer

My domain host hosts my MS SQL 2000 database. I am able to connect to it
from my workstation using the MS SQL Server Management Studio Express
application. I want to copy from the remote server, modify it, and upload it
back to my domain host.

I don't see any method of copying the remote database to my local machine.

Help???

19 Apr 2006 9:08 AM

doller

Hi,
u can backup the database to the remote server or mirror the backup
to remote location.
u should have permission on the shared folder of the remote server.
for mirroring see help

HTH
from
Doller

19 Apr 2006 9:09 AM

doller

Hi,
u can backup the database to the remote server
u should have permission on the shared folder of the remote server.

HTH
from
Doller

20 Apr 2006 3:03 AM

Noozer

"doller" <sufiana***@gmail.com> wrote in message
news:1145437778.697809.321740@z34g2000cwc.googlegroups.com...
> Hi,
> u can backup the database to the remote server
> u should have permission on the shared folder of the remote server.

I am able to generate the backup on the remote server, but I have no access
to actually download the backup once generated.

I do have a local MS SQL 2005 server, but I can't see any method to backup
from the remote server to the local server.

20 Apr 2006 6:42 AM

Tibor Karaszi

BACKUP is executed by SQL Server, so the backup file will be generated by SQL Server. Either direct
the file to the desired location when you do the backup (UNC path) or do it locally and then grab
the file (COPY, FTP etc).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Noozer" <dont.spam@me.here> wrote in message news:6SC1g.41524$P01.35165@pd7tw3no...
>
> "doller" <sufiana***@gmail.com> wrote in message
> news:1145437778.697809.321740@z34g2000cwc.googlegroups.com...
>> Hi,
>> u can backup the database to the remote server
>> u should have permission on the shared folder of the remote server.
>
> I am able to generate the backup on the remote server, but I have no access to actually download
> the backup once generated.
>
> I do have a local MS SQL 2005 server, but I can't see any method to backup from the remote server
> to the local server.
>
>
>