Re: How to restore a database onto different server with mdf and ldf file only
From: Simon Lenn (simonlenn_at_yahoo.com)
Date: 08/22/04
- Next message: Steve Kass: "Re: Linked server to as400 - for the love of god please help."
- Previous message: Hari Prasad: "Re: Data designer"
- In reply to: Hari Prasad: "Re: How to restore a database onto different server with mdf and ldf file only"
- Next in thread: Hari Prasad: "Re: How to restore a database onto different server with mdf and ldf file only"
- Reply: Hari Prasad: "Re: How to restore a database onto different server with mdf and ldf file only"
- Messages sorted by: [ date ] [ thread ]
Date: 21 Aug 2004 21:40:06 -0700
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:<e2tvre6hEHA.3664@TK2MSFTNGP11.phx.gbl>...
> Hi,
>
> You could try attaching the database into another SQL server.
>
> 1. Copy the MDF and LDF to the new sql server
> 2. Execute the below command:-
>
> sp_attach_db 'dbname','drive:\path\dbname.MDF','drive:\path\dbname.LDF'
>
> 3. After this you may need to syncronize the user inside the database with
> syslogins in new server.
>
> See procedure sp_change_users_login in books online.
>
> Thanks
> Hari
> MCDBA
Hari
Many Thanks. It was a cool tip I did not even do Sp_change_users I was
able to recover my database that was really cool.
Many thanks for your help. I can't thank you enough so much of effort
was in this database and I did not have a good backup of the database
I have taken a backup now!!
Many Thanks again for your help. I can sleep for the weekend.
Simon
- Next message: Steve Kass: "Re: Linked server to as400 - for the love of god please help."
- Previous message: Hari Prasad: "Re: Data designer"
- In reply to: Hari Prasad: "Re: How to restore a database onto different server with mdf and ldf file only"
- Next in thread: Hari Prasad: "Re: How to restore a database onto different server with mdf and ldf file only"
- Reply: Hari Prasad: "Re: How to restore a database onto different server with mdf and ldf file only"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
