Saturday, February 25, 2012

restore a backup db 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
Yes, you can use OSQL.EXE and from there execute your RESTORE command. Both OSQL and RESTORE are
documented in Books Online, which you can find here:
http://www.microsoft.com/sql/techinf...0/default.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Martin" <martinsm@.freenet.de> wrote in message news:uE7SAxn0FHA.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
>
>
|||Am Sun, 16 Oct 2005 15:36:34 +0200 schrieb Martin:

> 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
You can use DbaMgr2k from http://www.asql.biz/DbaMgr.shtm
A free and mighty Admin-Tool for SQL-Server and MSDE, can backup and
restore too.
bye,
Helmut

No comments:

Post a Comment