Saturday, February 25, 2012

restore a bakup database on MSDE

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
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/d...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
>
>
|||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@.hotmail.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/d...displaylang=en
> Thanks
> Hari
> SQL Server MVP
>
> "Martin" <martinsm@.freenet.de> wrote in message
> news:ulVz$wn0FHA.164@.TK2MSFTNGP10.phx.gbl...
>
|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.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/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en[vbcol=seagreen]
> Thanks
> Hari
> SQL Server MVP
>
> "Martin" <martinsm@.freenet.de> wrote in message
> news:ulVz$wn0FHA.164@.TK2MSFTNGP10.phx.gbl...
Manager"
>

No comments:

Post a Comment