Results 1 to 3 of 3

Thread: Replicating to older version of SQL

  1. 01-22-2013, 11:35 AM #1
    goodson
    goodson is offline Registered User
    Join Date
    Jan 2013
    Posts
    2

    Replicating to older version of SQL

    Is it possible to backup/restore a SQL database from a 64-bit, SQl 2008 R2 instance --> 32-bit, SQL Server 2000 instance? I am thinking its not - just looking for confirmation.

    Thanks!
    Reply With Quote Reply With Quote
  2. 01-22-2013, 01:05 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    No, you can not restore to older version of SQL Server. Your one choice is to use SSIS to copy tables and data.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
  3. 01-22-2013, 01:07 PM #3
    goodson
    goodson is offline Registered User
    Join Date
    Jan 2013
    Posts
    2
    Thought so. Sounds like I need to upgrade that server.

    Thanks for the confirmation.
    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