Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different ways of moving data or databases
between servers and databases in SQL Server?
- 3 Answers
- 8389 Views
- I also Faced
- E-Mail Answers
Answer Posted / pandians
Moving Data :
-------------
1. Configuring Linked Server between servers and move the
data using four part naming convension
i.e: Server.Database.Schema.Table
2. Use Export and Import wizard
3. Using SSIS or DTS Package to move data to different
database or server
4. Use three part naming convension to move data to
different database within the server/instance.
5. Using BCP to move data.
Moving Database:
----------------
1. Detach...Attach
2. Backup and Restore
3. Stop the Service
3.1 Using Alter statement to relocate the database path
3.2 Copy the files into new location
3.3 Start the Service
4. But, Moving system database except Master and Resource
can follow the above way
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is ora 24313?what is the procedure to exclude that error?
how does an oracle clusterware manage crs resources?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a system database and what is a user database? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how to restore files with rman?
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.
how can you record information about current session?
how can you initialize log miner?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
