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
- 8656 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
how can you connect from 10g user to 11g user??
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the steps you will take to improve performance of a poor performing query?
What happens on checkpoint? : sql server DBA
how can a session indicate its interest in receiving alerts?
What are the different sql server versions you have worked on? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you get actual data change values from previous transactions in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
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?
