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

When I run the sql server 2000 setup, it just hangs. What do I do?

643


What is the language structure to add a record to a table?

568


What is replace and stuff function in sql server?

559


Why the trigger fires multiple times in single login?

715


Explain what is the use of custom fields in report?

491






Explain the different types of backups available in sql server? : sql server database administration

512


What is difference between table aliases and column aliases? Do they affect performance?

503


Can you force a query to use a specific index?

522


What is nolock hint in sql server 2008

623


In which format does an image save in SQL Server database ?

581


What is normalization 1nf 2nf 3nf?

620


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

739


What is difference between line feed ( ) and carriage return ( )?

511


What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

548


what are triggers? : Sql server database administration

491