restore database from a bak file

Can I restore a sql server 2000 database to msde from a bak file ?
if so how ?
Without more details, from a command line, something like
osql -E (local)\<instancename> -Q"RESTORE DATABASE <dbname> FROM
DISK='c:\<file>.bak'"
Obviously, replace <data> with real values.
http://www.aspfaq.com/
(Reverse address to reply.)
"TJS" <nospam@.here.com> wrote in message
news:10qpf3idvcegna9@.corp.supernews.com...
> Can I restore a sql server 2000 database to msde from a bak file ?
> if so how ?
>
|||the following fails so what else might be required ?
there 's only one copy of msde running
osql -E (local) -Q "RESTORE DATABASE 'restored' FROM DISK='C:\export.bak'"
|||hi,
"TJS" <nospam@.here.com> ha scritto nel messaggio
news:10qtlu69djgjh1a@.corp.supernews.com
> the following fails so what else might be required ?
> there 's only one copy of msde running
>
> osql -E (local) -Q "RESTORE DATABASE 'restored' FROM
> DISK='C:\export.bak'"
try
c:\>osql.exe -E -S(local) -Q "RESTORE DATABASE [restored] FROM DISK =
'C:\export.bak'"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||It says it cannot find "C:\>osql"
|||Wow.
Start typing at osql. The C:\> was supposed to look like the command
prompt.
http://www.aspfaq.com/
(Reverse address to reply.)
"TJS" <nospam@.here.com> wrote in message
news:10qutlo817krn2b@.corp.supernews.com...
> It says it cannot find "C:\>osql"
>
>
|||nothing happens, the dos window just flashes by
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uYYJlwK2EHA.3452@.TK2MSFTNGP14.phx.gbl...
> Wow.
> Start typing at osql. The C:\> was supposed to look like the command
> prompt.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "TJS" <nospam@.here.com> wrote in message
> news:10qutlo817krn2b@.corp.supernews.com...
>
|||Wow again.
OPEN a command prompt. (Start | Run | CMD, enter)
Type "osql..." without the quotes, and hit enter.
Now the dos window won't "flash by"...
http://www.aspfaq.com/
(Reverse address to reply.)
"TJS" <nospam@.here.com> wrote in message
news:10qv11fjl5u9864@.corp.supernews.com...
> nothing happens, the dos window just flashes by
>
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:uYYJlwK2EHA.3452@.TK2MSFTNGP14.phx.gbl...
>
|||that worked...
thanks to all