Instance Properties

Question

Post reply

Instance Properties

db2l

Ten Centuries

Points: 1386
More actions
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.

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

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

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

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

Greg

db2l Ten Centuries Points: 1386 More actions · Answer 2

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?

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 3

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

venu_ksheerasagaram SSCommitted Points: 1911 More actions · Answer 4

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

Marcin Gol Hall of Fame Points: 3314 More actions · Answer 5

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..