Restore Newbie

I am trying to install and run a prototype VB.net application for review
I have desktop edition of SQL2K installed and running.
I have a .bak file that I need to load for the applications data
How do I do restore?
I've seen posts where one runs the restore command, but I cannot find an executable called restore.exe?Allan,
It's a T-SQL command.
RESTORE DATABASE.
Or, you can do it from Enterprise Manager.
Either way, look at RESTORE DATABASE in Books Online.
James Hokes
"Allan" <anonymous@.discussions.microsoft.com> wrote in message
news:E467A676-703B-4636-BAE0-19B4BB6DD55B@.microsoft.com...
> I am trying to install and run a prototype VB.net application for review
> I have desktop edition of SQL2K installed and running.
> I have a .bak file that I need to load for the applications data
> How do I do restore?
> I've seen posts where one runs the restore command, but I cannot find an
executable called restore.exe?
>
>

restore msdb - MSDE 2000

hi. i'm trying to restore msdb (dmp)... the dmp was taken from MS Desktop Engine 2000 and i'm trying to restore it to ms sql server 2000. is this possible? if not, how can i restore msdb to MSDE 2000? can't remember the command. (matter is a little urgent)

Thanks!

First, Stop the SQL Server Agent Service, then start the SQL Server Service and execute it:

RESTORE DATABASE msdb FROM DISK='c:\backup\msdb_backup.bak'

Regards and Happy new Year,

|||

The structure does not differ from MSDE or a greater version of SQL Server 2k. use the kb article here to go the offical way.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html a good one.