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

What is auditing in sql server?

509


Can you please explain the difference between primary keys and foreign keys?

664


how will add additional conditions in sql?

579


what is an index? : Sql server database administration

529


What is tablix?

115






Explain linked server in sql?

702


You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

609


What are the new features of sql server 2012 reporting service?

84


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

564


Why do we partition data?

622


what stored procedure can you use to display the current processes? : Sql server administration

534


How do you trace the traffic hitting a sql server?

624


What are the results of running this script?

515


write an SQL query to list the employees who joined in the month of January?

1161


what is package and it uses and how can u call a package

1569