Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2005
    Posts
    1

    Unanswered: RE: Creating A Duplicate Database Without Enterprise Manager

    Hi There,

    I was wondering if there was a simple way of create a duplicate of an entire database.

    I often need to create a second copy of a database for development purposes. I have lost the use of Enterprise Manager which I can no longer simply script the database and then use dts to move the data across.

    Is there a way of doing this in T-SQL?


    Thanks

    Steve

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Take a full backup and restore as a different name ... that should do it .. i think ... rather than going about it the other way round.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You lost the use of Enterprise Manager?

    HUH?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I think they're an amputee
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Perhaps it was destroyed by a Klingon Manager?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Or a Romulan cloaking device has been attached, so it's really there, he just can't see it ;-)

    -- This is all just a Figment of my Imagination --

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Could have been an Organian illusion all along...

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55463
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •