Re: HELP on How to move database files
From: Mac Vazehgoo (mahmood.vazehgoo_at_unisys.com)
Date: 08/27/04
- Next message: Amanda: "SSPI Context issue"
- Previous message: Andrew J. Kelly: "Re: Memory limited to 1.24 GB"
- In reply to: John McLusky: "Re: HELP on How to move database files"
- Next in thread: ChrisR: "Re: HELP on How to move database files"
- Reply: ChrisR: "Re: HELP on How to move database files"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Aug 2004 10:45:07 -0700
Thank you Chris for the suggestion and John confirming the approach.
What do you mean by turn off SQL ? When I Detach a database, isn't it off
?
"John McLusky" <jmclusky@community.nospam> wrote in message
news:OOOGklFjEHA.3972@tk2msftngp13.phx.gbl...
> ChrisR wrote:
> > If Im not mistaken, you would:
> >
> > Detach.
> > Turn off SQL.
> > Delete log file.
> > Turn on SQL.
> > Attach single file with sp_attach_single_file_db.
> >
> > DO THIS IN TEST FIRST. IVE NEVER DONE IT!!!
>
> I've never had any problems doing this. I'd certainly make a copy of both
> the MDF and LDF files before doing it, though.
>
> John.
>
>
- Next message: Amanda: "SSPI Context issue"
- Previous message: Andrew J. Kelly: "Re: Memory limited to 1.24 GB"
- In reply to: John McLusky: "Re: HELP on How to move database files"
- Next in thread: ChrisR: "Re: HELP on How to move database files"
- Reply: ChrisR: "Re: HELP on How to move database files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
