Results 1 to 3 of 3

Thread: Restore sql 2000 into sql express 2005

  1. Aug 8th, 2008, 10:58 AM #1
    venerable bede
    venerable bede is offline

    Thread Starter
    Fanatic Member venerable bede's Avatar
    Join Date
    Sep 2002
    Location
    The mystic land of Geordies
    Posts
    1,018

    Restore sql 2000 into sql express 2005

    I have a database in sql server 2000 and need to backup and restore it onto sql express 2005 which is installed on the same server.

    I was hoping I could just backup the sql server 2000 db and restore it but that doesn't seem to work.

    Anyone have any ideas ?

    TIA

    Parksie
    Reply With Quote Reply With Quote
  2. Aug 8th, 2008, 11:09 AM #2
    riteshjain1982
    riteshjain1982 is offline
    Frenzied Member
    Join Date
    Jan 2006
    Posts
    1,875

    Re: Restore sql 2000 into sql express 2005

    how did you tried to restore it (using enterprise Manager?)? did you got any message?
    __________________
    Rate the posts that helped you
    Reply With Quote Reply With Quote
  3. Aug 9th, 2008, 10:06 AM #3
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Restore sql 2000 into sql express 2005

    It most certainly does work - BACKUP in a query window - makes a .BAK file.

    RESTORE in another query windows restores it and converts it up to 2005 level.

    You cannot go back the other way!!

    If you need to see example of the BACKUP and RESTORE syntax search the forum for BACKUP FUNDS

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width