Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoring SQl SERVER 2008 R2 Expand / Collapse
Restoring SQl SERVER 2008 R2
Poll ResultsVotes
Hi Guys:
0%
0
 
50%
1
Any guide how to restore sql server 2008 r2 backup on sql server 2000
0%
0
0%
0
thanx
0%
0
symun
 
50%
1
Member Votes: 2, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Tuesday, April 30, 2013 7:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 5, 2013 6:21 AM
Points: 2, Visits: 4
Hi Guys:

Any guide how to restore sql server 2008 r2 backup on sql server 2000

thanx
symun
Post #1448041
Posted Tuesday, April 30, 2013 8:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:50 PM
Points: 1,166, Visits: 1,190
You can't restore a newer/higher version of SQL Server to an older version (e.g. 2008 R2 --> 2000). You can go the other way (older to newer), though that doesn't help you in this situation.

That being said, how large is the database? Can you script out the database and tweak the SQL to create the DB structure on the 2000 server (being careful to remove any newer features not in 2000). Then perhaps use SSIS to move the data from the 2008 R2 server to your newly created 2000 db.

Just a thought,
Rob
Post #1448047
Posted Tuesday, April 30, 2013 8:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 13,103, Visits: 11,933
No need to script it. Just use the Data Export Wizard.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1448078
Posted Tuesday, April 30, 2013 8:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
U can only script the Structures of Tables, Stored Procedure, Functions & Views & then run that script on 2000..

Regarding data.. just create a DB manually on 2000 same as it was on 2008 & then use Import/ Export Data & transfer the data between both servers.. this is what i know..

Experts are here to guide you more on this (Example - Gail)








************************************
Every Dog has a Tail !!!!!
Post #1448080
Posted Tuesday, April 30, 2013 8:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 13,103, Visits: 11,933
OnlyOneRJ (4/30/2013)
U can only script the Structures of Tables, Stored Procedure, Functions & Views & then run that script on 2000..

Regarding data.. just create a DB manually on 2000 same as it was on 2008 & then use Import/ Export Data & transfer the data between both servers.. this is what i know..

Experts are here to guide you more on this (Example - Gail)


You can script the entire thing including data if you want. Depending on the amount of data this may be unrealistic of course.

Certainly you don't need to create the DB manually. Use the generate scripts feature, make sure you hit the advanced section so you can script all the indexes and such.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1448086
Posted Tuesday, April 30, 2013 8:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Yup Sean, i missed to specify that.. thanks for correction







************************************
Every Dog has a Tail !!!!!
Post #1448088
Posted Wednesday, May 1, 2013 4:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 5, 2013 6:21 AM
Points: 2, Visits: 4
Hi gentleman..

No way to restore backup of sql 2008 r2 to sql 2000
Post #1448370
Posted Wednesday, May 1, 2013 7:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:28 PM
Points: 13,103, Visits: 11,933
As Rob said in his first post....NO. You can't restore a newer versions backup on an older version.

All of the subsequent posts explain in detail how you can get the data and the structures back to 2000.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1448410
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse