When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Answer / Rajeev Arkvanshi
Yes, it is possible to have the distributor on SQL Server 2005 and the publisher on SQL Server 2008 as they support cross-version replication.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the dataguard background process??
what is the difference between hot backup n rman backup?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Explain the concept of the DUAL table.
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
Explain the use of table functions.
what is grd?
how can you record information about current session?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how do see how much space is used and free in a tablespace
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)