Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    7

    Unanswered: Restore system dbs from SP3 to SP3a?

    Can system databases (master, model, msdb) backed up from SQL2k SP3 be restored to an instance of SP3a? Can they be restored from SP3a to SP3? TIA!

  2. #2
    Join Date
    May 2004
    Posts
    73
    Not going to happen buddy. try installing a fresh copy of sql server somewhere else upgrade to sp3, restore your system db's there, upgrade to sp3a then move the system db's to the live server. hope this helps.
    Last edited by X-Centric; 01-14-05 at 13:11.

  3. #3
    Join Date
    Jan 2005
    Posts
    7
    Thanks - that's what I thought. However, how can it be determined which SP (3 or 3a) a given instance is running? @@version returns 8.00.760 for both of them, & Properties in EM show SP3 for both. I remember there being a way to find the build number, but I don't know how to get it. TIA.

  4. #4
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63
    Check with MS website at the SP3/SP3a download pages. They usually have a section that tells you how to determine which SP you're currently running under.

  5. #5
    Join Date
    Dec 2004
    Location
    CA, USA
    Posts
    63

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •