Results 1 to 7 of 7

Thread: It's not doable

  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: It's not doable

    I know it's not doable but I thought I should still ask the Gurus on this board:

    Can I restore a master database backed up on server A to a new Server B.

    Case1: Server A and Server B has the same structure, file system and drive specificiation, I think it's doable in that case.

    Case2: Server A and Server B has different file system like c:\ and d:\ on A and C:\ and E:\ on Server B. It's nor DOABLE right?

    Case3: Server A is called Server A and Server B is called B, then also we cannot restore the master database, RIGHT?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Never done it...

    but why not....you'll have to identify the new physical location in the restore..

    like

    Code:
    RESTORE DATABASE TaxReconDB_Prod
       FROM DISK = 'D:\Tax\BackUp\TaxReconDB.dmp'
       WITH   MOVE 'TaxReconDB_Data' TO 'D:\Database\NJROS1D151DEV\MSSQL$NJROS1D151DEV\Data\TaxReconDB_Prod_Data.MDF' 
            , MOVE 'TaxReconDB_Log'  TO 'D:\Database\NJROS1D151DEV\MSSQL$NJROS1D151DEV\Data\TaxReconDB_Prod_Log.LDF'
    	, REPLACE
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If I had to make a guess, I'd say that you could RESTORE MASTER, but that doesn't make it a good idea!

    -PatP

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I've never done it....Pat?

    I guess in some cases, when it's corrupted you have no choice...

    knock on wood

    Why do you want to do this...I bet it's some "clever" shortcut...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It is a common trick for upgrading server hardware. You run up the new box (offline) with the same name and IP as the old box. You then restore master and reattach the other databases, and life is good!

    -PatP

  6. #6
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    As far as the locations and the drive specification are same, you are safe. But if the system databases where on a different drive on the old server than the new one, then you are in trouble.

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Originally posted by sqlserver2k
    As far as the locations and the drive specification are same, you are safe. But if the system databases where on a different drive on the old server than the new one, then you are in trouble.
    Why is that? We move from C: to E: (and back) all of the time.

    -PatP

Posting Permissions

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