Re: restore database from a bak file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 13:33:29 -0500

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 ?
>
>

Relevant Pages

  • Re: restore database from a bak file
    ... The C:\> was supposed to look like the command ... prompt. ... (Reverse address to reply.) ... "TJS" wrote in message ...
    (microsoft.public.sqlserver.msde)
  • Re: sed search and replace
    ... As you supplied the full command the first comma is replaced by 3 ... If I reverse the 2 and 3rd sub commands it works fine....strange. ... Any other comments on whether I should investigate Perl as our data ... Can't afford to go down the wrong path. ...
    (comp.unix.shell)
  • Re: Reverse a file
    ... > command to reverse characters in a line. ... the cut command will treat it as delimiter ...
    (comp.unix.shell)
  • Reverse a file
    ... command to reverse characters in a line. ... the cut command will treat it as delimiter ...
    (comp.unix.shell)
  • Re: Reverse a file
    ... >command to reverse characters in a line. ... the cut command will treat it as delimiter ... This will not effect any other COLON characters on the line, ...
    (comp.unix.shell)