Enterprise Version Backup Restore on Standard Version

  • Can a backup created on SQL Server 2008 Enterprise version be restored on SQL Server 2008 Standard version?

    Thanks!

  • yes.

    a backup is saved as a specific version, ie SQL 2008, so you can restore it on any same or higher version , ie Standard/Developer/Enterprise/Workgroup/Small Business/Express as well(given the db is under the Express 4 gig limit);

    the Enterprise vs Standard is a limiter on what features may be used to access the data formt he SQL service, but not HOW the database is saved.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply