What are the different ways of moving data or databases
between servers and databases in SQL Server?
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
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How can you control the amount of free space in your index pages? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what is the role of dip user in our database?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What happens on checkpoint? : sql server DBA
How to start SQL Server in minimal configuration mode?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?