How to use UNC path to syncronize data

Can you do a backup of that database on your WHP's server,
and then download the .bak file to your pc? If yes, then
you can restore the .bak file as a new database on your PC
or overwrite existing database.
I don't know anything about the ASP.Net Enterprise Manager
so I have to ask you this dumb question: What kind of
access do you have to the remote sql server from your
local pc?
hth.

>--Original Message--
>Hello:
>I'm working with the SQL server database that is located
on my web hosting
>provider's server. I can control it by ASP.Net Enterprise
Manager, which is
>very limited comparing to the regular Enterprise Manager.
I need to
>syncronize data on this server with the data in another
SQL server on my PC.
>I've never done this before. I know that I have to do it
programmatically
>using T-SQL statements that use UNC path to import and
export data. Where
>can I learn more about it? Could you recommend me some
articles about it or
>give me some code examples?
>I would appreciate your suggestions.
>Thank you,
>--
>Peter Afonin
>
>.
>Thank you.
My WHP can do daily backups of my database, but I cannot download them.
I don't actually have any access directly from my PC to the remote SQL
server. I use this ASP Enterprise Manager which is actually an ASP.Net
application (www.aspenterprisemanager.com) that I installed in my web space
and that imitates SQL server Enterprise manager, but is much more limited.
Peter
<anonymous@.discussions.microsoft.com> wrote in message
news:deb501c3f0b4$474bb7f0$a101280a@.phx.gbl...
> Can you do a backup of that database on your WHP's server,
> and then download the .bak file to your pc? If yes, then
> you can restore the .bak file as a new database on your PC
> or overwrite existing database.
> I don't know anything about the ASP.Net Enterprise Manager
> so I have to ask you this dumb question: What kind of
> access do you have to the remote sql server from your
> local pc?
> hth.
>
> on my web hosting
> Manager, which is
> I need to
> SQL server on my PC.
> programmatically
> export data. Where
> articles about it or

How to use import/export utility in Sql Server 2000

Hi,

I've a data back up of sql server 2000 database in .bak form. I want to import data from this .bak file using the import/export utility. But there is no .bak option available in datasource select button of import/export utility. Then, what is the way to import data from .bak file?

you can not use import/export wizard in this scenario. You should restore database. Use Restore Command. Read about Restore with Move option in BOL(books online)

copied from BOL :

RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\test\testdb.mdf',
MOVE 'Northwind_log' TO 'c:\test\testdb.ldf'

Madhu

|||I have marked Madhu's response as it stands, further do not attempt to open this .bak file as it is a database backup file and only by using RESTORE statement you would be able to restore on the other SQL server to extract the data using import/export wizard.|||

Hi

Madhu's suggestion worked well. I am able to restore.