Re: how to restore

Really, I have been annoyed by it so much. here thank u very much. I am
going to check sp_attachdb right now.

thank u again
"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:OQbf99qZFHA.3488@xxxxxxxxxxxxxxxxxxxxxxx
> Easy, look for SP_attachDB in the BOL, everything explained there along
with
> samples.
>
> --
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
> "hui" <gary1971_cn@xxxxxxx> schrieb im Newsbeitrag
> news:%23WKLI6qZFHA.1152@xxxxxxxxxxxxxxxxxxxxxxx
> >I have a copy of Data File and Log File, named pms_bak.mdf and
pms_bak.ldf.
> > May I restore them into my new sql server? How can I do?
> >
> > thank u
> >
> >
> >
> >
>
>


.

Relevant Pages

  • Re: Efficient way of comparing items in an array
    ... Dave Tang wrote: ... Oops I mean and sorry for the double post. ... if ($prev eq 'NULL'){ ... Another more likely problem if your data file is too big is that the slowdown might be due to disk accesses -- and if so, there isn't much I can think of which you can do. ...
    (perl.beginners)
  • Re: System table 13 error - trying to upgrade 7 to 2K
    ... All of the system tables live in the First data file (called the Primary ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > I did a simple backup from sql 7 and tested the restore> back to 7, then created a blank db in my sql 2000 system,> then tried to restore the MEX database. ...
    (microsoft.public.sqlserver.server)
  • Partial Restoration
    ... We have taken a full database dump in sql server 2000. ... Now we want to restore only the data file without restoring the log file. ...
    (microsoft.public.sqlserver.server)
  • Re: Populate from text file
    ... If it's an ordinary text data file just use ... John Nurick [Microsoft Access MVP] ... Please respond in the newgroup and not by email. ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: get the first word of a file
    ... >> I have a data file of the format ... cat serves no purpose. ... Prev by Date: ...
    (comp.unix.shell)
Loading