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
What would you do with an "in-doubt" distributed transaction?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are statistics, under what circumstances they go out of date, how do you update them?
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.
What is the default fill factor value? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
You create a private database link and upon
connection, fails with: ORA-2085: connects to
when does an alert gets signaled?
What is replication? : sql server DBA
how can you communicate with operating system files from oracle?
what is the diffrence between core dba and apps dba?
Why does Oracle not permit the use of PCTUSED with indexes?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA