Downgrade database SQL 2005 to SQL 2000

Results 1 to 3 of 3
  1. #1
    Apprentice FunPeople is offline
    MemberRank
    Nov 2012 Join Date
    Buenos AiresLocation
    23Posts

    Downgrade database SQL 2005 to SQL 2000

    Helly everyone and thank you for reed.
    I have some problems to downgrade the database, I try and try but i can't do it.

    Can anyone help me to do it?


  2. #2
    Member 7GNJumper is offline
    MemberRank
    Apr 2013 Join Date
    IstanbulLocation
    51Posts

    Re: [HELP] Downgrade database SQL 2005 to SQL 2000

    You cannot restore your database to lower version as Micrasoft says.

    Only way u can do this with create a database script an make it sqls2000 compabilty,

    Modify the script, to specify the correct location for the OUTLANDER database data and log files. Once done, run the script to create the OUTLANDER database on IITCUK\SQLServer2008 instance.
    then run it it might be take serious time to get job done.

  3. #3
    Member 7GNJumper is offline
    MemberRank
    Apr 2013 Join Date
    IstanbulLocation
    51Posts

    Re: [HELP] Downgrade database SQL 2005 to SQL 2000

    You cant do restore your databese to lowes version sql as Micrasoft says, only way u can do this with making script on sql its long way to explain all here but its possible this way.

    key on google : how-to-migrate-a-sql-server-database-to-a-lower-version/

    good luck.



Advertisement