Results 1 to 3 of 3
  1. #1
    manik's Avatar
    manik is online now Om Shanti!
    Join Date
    Apr 2008
    Location
    Boston, MA
    Posts
    13,232
    Thanks
    745
    Thanked 729 Times in 564 Posts
    Blog Entries
    4
    Feedback Score
    4 (100%)

    Default Restore Database in Older Versions of MS SQL

    If you backup your database from a newer version, and then try to restore it in a older version of a MS SQL database you will get error. MS SQL simply doesnt seem to allow it.

    To overcome this you could take an alternative like this:


    • Open SQL Server Management Studio
    • Click to select your source Database
    • Right click on your source database
    • Select Tasks>Generate Scripts.
    • Select 'Script entire database and all database objects', press 'Next'
    • Select 'Save to File' and click on the 'Advanced' button
    • Select 'Script for Server Version' and select the version you want: 200/2005/2008
    • Select 'Type of data to Script' and select Schema/Data/both
    • Click 'OK',Next and follow the steps.
    • Copy the file from the generated file.
    • Log onto your SQL Management Studio in your target maching and open the copied .sql file.
    • There may also be issues with the order that the .SQL file inserts the data into the target database and if there are FK constraints in place, this could be an issue.... simply re-order the insert lists.
    • Once the .sql file is organised, parse it [just to sure], and then execute.
    Free Classified Ads & BUSINESS/PROFESSIONAL SOCIAL NETWORK


  2. #2
    Jagbani is offline Sophomore
    Join Date
    Jul 2010
    Location
    punjab
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Feedback Score
    0

    Default

    you have posted the best topic and you have given the good solution......
    Thank you.........

  3. #3
    mandy is offline Junior
    Join Date
    Apr 2011
    Posts
    331
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Feedback Score
    0

Similar Threads

  1. How many times have you ever restore your system?
    By Hoa in forum Computer and Tech
    Replies: 63
    Last Post: 03-13-2013, 04:59 AM
  2. Older Woman/Young Girl
    By greenlea in forum General Talk
    Replies: 12
    Last Post: 06-21-2012, 05:18 AM
  3. Invalid Key Error on Setting Restore - VBSeo
    By manik in forum Forum Management
    Replies: 0
    Last Post: 06-07-2010, 09:31 PM
  4. Older Versions of IE for Testing
    By manik in forum Web Development - Programming & Coding
    Replies: 9
    Last Post: 12-18-2008, 02:40 AM
  5. Different versions of Adidas in India
    By himoacs in forum General Talk
    Replies: 8
    Last Post: 06-13-2008, 03:12 AM

Tags for this 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
  •  
Partners: BOSTON WEB DEVELOPER, LLC   |   WEBCOSMO CLASSIFIEDS