Results 1 to 5 of 5
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    SQL SEVER DATABASE COPIES (2005)

    OK, I know this is NOT really the place to ask this BUT!
    I have an Access Database linked Via ODBC (rather) than a Project
    There are Reasons for this!

    I need to make a copy of the SQL Server Database that I can test on another machine at home.
    I DO not have remote access to the server from home so need to take a copy.

    Could I do this using backup and restore to a new database?

    Thanks
    Andrew

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: SQL SEVER DATABASE COPIES (2005)

    I seem to be answering my own questions tonight.

    I have tried this here moving a database from one PC to another via USB Pen and
    it appears that the Backup and then Restore from Device option works.

    Incidentally this is also best if you want to make a copy of a database inside the SQL management interface.

    Make a Backup and then Restore to a New Name that does not exist.

    If you use the Copy Database Option from Tasks it copies all the data and structure
    but appears to leave behind any relationships as well as things like Identity settings and default values et5c

    Ah Ha.. Microsoft dies it again!
    Andrew

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL SEVER DATABASE COPIES (2005)

    If you want to copy a database, you can do so just by right clicking the database in enterprise manager, selecting All Tasks and then selecting Detach Database. The database can then be copied from the Windows explorer. Then switch back to EM, right click the databases node and select All Tasks again. Use the Attach Database option to select and reattach both the original and the new copy.
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: SQL SEVER DATABASE COPIES (2005)

    Sorry, I just noticed belatedly the 2005 version. I'm still working with 2000, so I can't guarantee the tools are the same.
    Charlotte

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: SQL SEVER DATABASE COPIES (2005)

    For what it's worth, the tools aren't the same - I'm currently working with both and the jury is still out on whether I like the changes. It seems to me the 2005 SQL Server Management Studio is somewhat slower than Enterprise Manager. But I am able to take a database and move back and forth from 2000 to 2005 - which is a very good thing in my case. The other thing I've found is that the SQL Server 2005 Express tools are much better than what we've had in the past for the MSDE. Now making it work with ODBC connections seems to be a bit of a challenge however.
    Wendell

Posting Permissions

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