What are the different ways of moving data/databases
between servers and databases in SQL Server?

Answer Posted / venkat reddy.ravu

You can use simple backup/restore methods,attach and
detach,script based data loading,bulk DDL state ments like
select...into,insert..into,Implimenting data availability
methods like replication,log-shipping,mirroring,clusturing
etc..

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me the disaster recovery plan

2031


How many types of schemas are there?

533


Where cross join is used?

523


How can sql injection be stopped? : sql server security

558


How to find table changes in sql server?

665






What stored by the tempdb ? : sql server database administration

573


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

539


What is #table in sql server?

539


What is 'Join' and explain its various types.

631


What is the purpose of sql profiler in sql server?

519


What is left outer join in sql server joins?

559


How many instances per computer are there in sql server 2000?

585


Can you explain what are commit and rollback in sql?

491


what is the difference between a primary key and a unique key? : Sql server database administration

533


What command would you use to add a column to a table in sql server?

754