Copying a database
From: DeeJay Puar (deejaypuar_at_yahoo.com)
Date: 08/24/04
- Next message: Steve Thompson: "Re: attach files to new box???"
- Previous message: Tibor Karaszi: "Re: reset sa password"
- In reply to: GoX: "Copying a database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 12:04:33 -0700
Sounds like you have a plan. This should work just fine.
DeeJay
>-----Original Message-----
>I want to copy a database, say d:\aa.mdf and d:\aa.ldf,
to
>the same server but with a different name. Of course, I
>can't use the Copy Database Wizard. Will the following
>work?
>
>1. Detach the database.
>2. Go into Win Explorer and make copies of the files,
say
>d:\aa1.mdf and d:\aa1.ldf.
>3. Re-attach the original database using d:\aa.mdf and
>d:\aa.ldf.
>4. Attach the copied files, d:\aa1.mdf and d:\aa1.ldf,
>with a different database name.
>
>I'm just wondering if the server or system tables will
get
>confused for some obscure reason. Thanks for the help.
>.
>
- Next message: Steve Thompson: "Re: attach files to new box???"
- Previous message: Tibor Karaszi: "Re: reset sa password"
- In reply to: GoX: "Copying a database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
