Post reply

make a copy of a sqlserver 2005 database on same server

  • April 4, 2008 at 3:14 am

    #128467

    What is the easist way to make a copy of a sqlserver 2005 database on the same server.

    As i need to use the database for test purposes

  • April 4, 2008 at 3:18 am

    #798271

    Take a backup and restore it as a new DB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 4, 2008 at 3:19 am

    #798272

    icampbell (4/4/2008)

    What is the easist way to make a copy of a sqlserver 2005 database on the same server.

    As i need to use the database for test purposes

    Backup, then restore with a different name

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • April 4, 2008 at 3:25 am

    #798278

    Thanks guys,

    ill give it a go.

  • April 4, 2008 at 4:13 am

    #798294

    It worked very quick and easy to do.

    Thanks for the advice guys!!!:D

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply