What are the different ways of moving data or databases
between servers and databases in SQL Server?
Answer Posted / monal
BCP (BULK COPY PROGRAM)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
internal architecture
What the different components in replication and what is their use? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can you get actual data change values from previous transactions in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Where do you find the default index fill factor and how to change it? : sql server DBA
What is replication? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.