adspace


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

How can I check that whether automatic statistic update is enabled or not?

1120


What is standby servers? Explain types of standby servers.

1087


What is in place upgrade in sql server?

1134


How can you append an identity column to a temporary table?

1074


Disadvantages of the indexes?

1230


Why we use the openxml clause?

1086


What is the difference between for xml raw and for xml auto?

1125


Why should you use or avoid select * statements?

1120


Can we do dml on views?

1041


How to connect php with different port numbers?

1196


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1303


How to convert character strings into numeric values?

1196


What kind of problems occurs if we do not implement proper locking strategy?

1508


What is the difference between upgrade and migration in sql server?

1190


What is sql or structured query language?

1231