Post reply

Version 65 database restore on SQL 2005??

  • May 14, 2007 at 11:25 am

    #178513

    Can a v65 database be restored on a sql 2005 machine without becoming a snapshot?  I want to be able to view all tables, logins etc.  If there is a way to view schema info within a snapshot, please advise.

    This is what I've already done to try to get this to work:

    Changed compatibility level of v65 db to v80 on a sql 2000 machine, backed up the file using a new device, copied backup device to sql2005 machine, restored db with no problems and was able to view schema, logins etc.  Once I changed the compatibility level back to v65 the db became a snapshot and I can no longer view tables or anything else.  Any feedback would be greatly appreciated.

  • May 15, 2007 at 9:44 am

    #706559

    i don't think its possible. that is probably due to the different architecture for 6.5 and 2005

    i once worked with a 6.5 database and I never bothered to use sql 2005 tools

    Everything you can imagine is real.

  • May 15, 2007 at 9:51 am

    #706562

    As far as I know, SQL 2005 has no facility for viewing a 6.5 version database.  It either has be 8.0 or 9.0.  There's a bit of information in SQL 2005 BooksOnLine under "Copying Databases from SQL Server 6.5 or Earlier".

    Greg

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

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