sql server msde: restore database from a bak file -- sql server msde

You're in the

sql server msde

group:

restore database from a bak file

TJS
11/30/2004 10:31:00 AM

sql server msde:

Can I restore a sql server 2000 database to msde from a bak file ?
if so how ?

Re: restore database from a bak file

Aaron [SQL Server MVP]
11/30/2004 1:33:29 PM

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.)

[quoted text, click to view]

Re: restore database from a bak file

TJS
12/2/2004 12:52:06 AM

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'"

Re: restore database from a bak file

TJS
12/2/2004 12:10:32 PM

It says it cannot find "C:\>osql"

Re: restore database from a bak file

Andrea Montanari
12/2/2004 12:25:11 PM

hi,
"TJS" <nospam@here.com> ha scritto nel messaggio
news:10qtlu69djgjh1a@corp.supernews.com
[quoted text, click to view]

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.shtm http://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

Re: restore database from a bak file

TJS
12/2/2004 1:07:56 PM

nothing happens, the dos window just flashes by

[quoted text, click to view]

Re: restore database from a bak file

TJS
12/2/2004 3:01:47 PM

that worked...
thanks to all

Re: restore database from a bak file

Aaron [SQL Server MVP]
12/2/2004 3:16:23 PM

Wow.

Start typing at osql. The C:\> was supposed to look like the command
prompt.

--
http://www.aspfaq.com/
(Reverse address to reply.)

[quoted text, click to view]

Re: restore database from a bak file

Aaron [SQL Server MVP]
12/2/2004 5:22:17 PM

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.)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn