Post reply

System Databases

  • April 17, 2009 at 9:00 am

    #155578

    Server One (S1) - SQL 2005 EE

    Server Two (S2) - SQL 2005 EE

    Both boxes installed and configured identically. Database locations, configuration settings.

    If I stop S2 services and replace the system databases (data + log) files on S2 from those on S1 and try to start SQL services on S2 would it come online and be happy?

  • April 17, 2009 at 10:36 am

    #979817

    I would not like to say the server would be happy. But it should be ok. You need to do some baby-sitting work after replacing the system databases, such as logins and user databases.

  • April 17, 2009 at 10:41 am

    #979823

    So technically, if I copy all the user databases as well along with the resource db, maintaining all the file locations the same, I could move to a different default instance of SQL Server.

  • April 17, 2009 at 10:52 am

    #979832

    It could work, but why? Perhaps we have other ideas.

  • April 17, 2009 at 11:40 am

    #979880

    I can think of a couple of reasons where this might be useful.

    1. Move to better hardware

    2. Replicating the file system to a hot site on an on-going basis

    However the reason for my posting is we're testing a storage replication product and some of them are using the second reason above.

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

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