An occurrence of a database component. This can mean very different things depending on the platform.

learn more… | top users | synonyms

2
votes
1answer
991 views

How to disable instance recovery in ORACLE?

I want my DB to stop instance recovery during opening, how to do it? I want it because it crashes when trying to do instance recovery, I am testing some cases and want to disable it Is there any ...
0
votes
2answers
392 views

Assigning a logical name to a sql instance

How can we assign a logical name to a sql instance please? We would need to as to property identify messages coming through from the server. Update Thanks much for your replies. Yes it is for the ...
6
votes
3answers
1k views

For Oracle, we mount the instance to the database or mount the database to the instance?

The following text is extract from oracle documentation. Start the instance, and mount and open the database. This can be done in unrestricted mode, allowing access to all users, or in ...
2
votes
2answers
1k views

How to make inter-database queries with dynamic SQL Server database name?

We have two database servers with SQL Server 2005, with two databases each. The secondary server have two SQL Server instances: one for development and other for reporting. Both instances on secondary ...
13
votes
3answers
2k views

What's the most effective way to duplicate an instance on SQL 2008?

We've got a simple database instance with just enough data in the databases to keep it useful, and we can use it for demonstration purposes, and I want to put a copy of it on my laptop so I can use it ...
11
votes
2answers
6k views

How do I change the instance name in MS SQL 2005 without installing a new instance?

I have an instance that really has nothing on it, it's merely been installed (it was intended for one project, but that never actually got done on this server, the project was done in duplicate on ...