Microsoft SQL Server Desktop Engine - restore a bakup database on MSDE

Author

restore a bakup database on MSDE

Martin

2005-10-27, 7:56 am

Hi,

I habe a MSDE 2000 on a server machine. I don't habe "Enterprise Manager" or
"SQL Analyzer".

How can I restore a backup database?

This machine had MS Access XP, I can write program with VB6. Is there anyway
to execute a SQL script "RESTORE DATABASE ..."?

Thanks for help
Martin

Hari Prasad

2005-10-27, 7:56 am

Hi,

You have 2 options:-

1. OSQL :- MSDE comes with command line utility OSQL. Using this you can
login to SQL Server and execute any TSQL command. For
Restore you can use RESTORE DATABASE command from OSQL.

2. Webadmin:- Web based free tool from microsoft. Download from below site:-

http://www.microsoft.com/downloads/...&displaylang=en

Thanks
Hari
SQL Server MVP

"Martin" <martinsm@freenet.de> wrote in message
news:ulVz$wn0FHA.164@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I habe a MSDE 2000 on a server machine. I don't habe "Enterprise Manager"
> or
> "SQL Analyzer".
>
> How can I restore a backup database?
>
> This machine had MS Access XP, I can write program with VB6. Is there
> anyway
> to execute a SQL script "RESTORE DATABASE ..."?
>
> Thanks for help
> Martin
>
>
>

Lee-Z

2005-10-27, 7:56 am

Option 3:
make a little program, logon to master database and execute restore database
statement

RESTORE DATABASE <dbname> FROM DISK <location> WITH MOVE <file name>, TO
<file name>, RECOVERY, REPLACE

(MOVE and TO twice, for ldf and mdf (more if ndf's))

Check out BOL for exact statement

Lee-Z

"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:%23bq4c3s0FHA.1132@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> You have 2 options:-
>
> 1. OSQL :- MSDE comes with command line utility OSQL. Using this you can
> login to SQL Server and execute any TSQL command. For
> Restore you can use RESTORE DATABASE command from OSQL.
>
> 2. Webadmin:- Web based free tool from microsoft. Download from below
> site:-
>
> http://www.microsoft.com/downloads/...&displaylang=en
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "Martin" <martinsm@freenet.de> wrote in message
> news:ulVz$wn0FHA.164@TK2MSFTNGP10.phx.gbl...
>
>

Martin

2005-11-17, 9:23 am

Thanks

"Hari Prasad" < hari_prasad_k@hotmai
l.com> schrieb im Newsbeitrag
news:#bq4c3s0FHA.1132@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> You have 2 options:-
>
> 1. OSQL :- MSDE comes with command line utility OSQL. Using this you can
> login to SQL Server and execute any TSQL command. For
> Restore you can use RESTORE DATABASE command from OSQL.
>
> 2. Webadmin:- Web based free tool from microsoft. Download from below
site:-
>
>
http://www.microsoft.com/downloads/...A798-C57A-419E-
ACBC-2A332CB7F959& displaylang=en[color
=darkred]
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "Martin" <martinsm@freenet.de> wrote in message
> news:ulVz$wn0FHA.164@TK2MSFTNGP10.phx.gbl...
Manager"
>
>

Sponsored Links