Post reply

Instance Properties

  • November 7, 2006 at 5:11 pm

    #175105

    Hi,

    Just a question regarding instance properties.

    If we restore a backup to a new server/instance, I guess we need to create the instance with the exact properties of the existing instance (eg, collation sequence, etc).  What is the best way to dump these instance properties so that we can restore a database on a different instance with the same instance properties.  (I hope this makes sense!).

    thanks.

     

  • November 8, 2006 at 9:12 am

    #670618

    User SERVERPROPERTY e.g. SELECT SERVERPROPERTY('collation').  See SERVERPROPERTY in BooksOnLine.

    Greg

  • November 8, 2006 at 4:49 pm

    #670735

    thanks, I was aware of that one, but I was asking more of what other things I need to consider.  What server properties to other people take note of when installing a new instance based on an existing instance?

  • November 9, 2006 at 10:46 am

    #670894

    Based on my experiences, the service pack and hot fix may affect your recovery, in particular, when you recover a system database.

  • August 31, 2009 at 4:07 am

    #1046772

    Hi friends,

    Here are some doubts regarding the Instances in SQL Server.

    1) Is there any effect to the processor (or) existing application performnce if a new instance was created on a machine.

    2) I am having a scenerio as follows: There are two servers like DEV and PRODUCTION. I need to move a DB from DEV to PROD , for this i am going to create a another instance on the PROD server. Suppose if my DB name on DEV is same as one of the DB present on the PROD, is it causes any conflict at the time of restoring a DB.

    Thakns in advance,

    Venu Gopal.K
    Software Engineer
    INDIA

  • September 7, 2009 at 12:39 pm

    #1050200

    what about virtualization ? you can do simple P2V (physilcal to virtual) you will get EXECTLY same machine. It is a very good solution for testing and so on..

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

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