compatible between sql server 2008 and sql server 2008r2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » compatible between sql server 2008 and sql...

compatible between sql server 2008 and sql server 2008r2

Rate Topic

Display Mode

Topic Options

Author

Message

elham_azizi_62

Posted Monday, October 08, 2012 1:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, April 27, 2013 5:33 AM
Points: 109, Visits: 390

hello all.
I back up data base from sql server 2008r2 and i want to restor this back up in sql server 2008 but get error.is exist any way for compatible between 2008 and 2008r2 when back up from r2?

Post #1369641

Nchax Phoku

Posted Monday, October 08, 2012 2:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 2:56 AM
Points: 32, Visits: 391

Hi,

You can't restore latest version to earlier one, rather import/export.

Regards

Post #1369660

mcopa

Posted Tuesday, October 09, 2012 6:20 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:54 AM
Points: 14, Visits: 62

You can also use the "Copy Database" function.

Post #1370358

Scott D. Jacobson

Posted Tuesday, October 09, 2012 7:38 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841

Make sure your backup is not compressed.

Post #1370394

« Prev Topic | Next Topic »

Permissions