Post reply

Restoring system databases to different SQL Edition

  • January 28, 2004 at 4:04 am

    #177851

    Is it possible to backup the system databases (master, msdb) from a SQL Enterprise Edition server and restore them to a SQL Standard Edition server?

  • January 29, 2004 at 12:00 pm

    #492236

    I can't say that I've done this with master, but msdb works (going from Standard to Enterprise) as long as they are both at the same SP/version level.

    Off the top of my head, I can't see why it wouldn't work with master, but experience is the best teacher...  Generally though, if you need to migrate from one instance to another I've found it easier to script out all the logins, any custom messages, and linked servers that I want to move and then move the user databases and then you don't need to worry about master.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • January 29, 2004 at 2:08 pm

    #492259

    I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.

  • January 29, 2004 at 2:08 pm

    #492258

    I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.

  • January 29, 2004 at 2:09 pm

    #492261

    I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.

    Good reason to know what SP level your backups are on.

  • January 29, 2004 at 2:09 pm

    #492260

    I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.

    Good reason to know what SP level your backups are on.

  • January 29, 2004 at 2:11 pm

    #492262

    I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.

    Good reason to know what SP level your backups are on.

  • January 30, 2004 at 1:54 am

    #492287

    Thanks all, especially Steve for SO many replies (I think he's trying to get increase his number of posts )

    Since starting this thread I have had the chance to perform this operation on a test server and I am gald to say that so long as the service packs are consistent, the restores work without a problem.

  • January 30, 2004 at 1:55 am

    #492288

    Thanks all, especially Steve for SO many replies (I think he's trying to get increase his number of posts )

    Since starting this thread I have had the chance to perform this operation on a test server and I am gald to say that so long as the service packs are consistent, the restores work without a problem.

Viewing 9 posts - 1 through 8 (of 8 total)

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