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
- 8361 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
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?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what functionality does oracle provide to secure sensitive information?
what is the diffrence between core dba and apps dba?
What purpose does the model database server? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the recovery models for a database? : sql server DBA
Where would you look for errors from the database engine?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what do you understand by flashback feature of oracle?
how to restore files with rman?
how can you find out if a table can be redefined?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
which background process invoke at the time of upgradation tell me???
