Re: how to restore

Thanks for that, thats right.

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> schrieb im Newsbeitrag
news:%23NMzPrsZFHA.2884@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> There was typo error in Jens post. The procedure name is sp_attach_db.
>
> Usage is:-
>
> sp_attach_db 'PMS','D:\mssql\data\pms_bak.mdf 'D:\mssql\data\pms_bak.ldf'
>
> Change the directtory to the actual one.
>
> Thanks
> Hari
> SQL Server MVP
>
> "hui" <gary1971_cn@xxxxxxx> wrote in message
> news:ewxtECrZFHA.1456@xxxxxxxxxxxxxxxxxxxxxxx
>> 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