Answer / swapna

There are lots of options available, you have to choose
your option depending upon your requirements. Some of the
options you have are: BACKUP/RESTORE, dettaching and
attaching databases, replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to
generate data.

Answer / javed shaikh

What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer
# 1 There are lots of options available, you have to choose
your option depending upon your requirements. Some of the
options you have are: BACKUP/RESTORE, dettaching and
attaching databases, replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to
generate data.

Answer / 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..

What is implicit cursors?

1 Answers  

---

What is public role in sql server?

1 Answers  

---

What happens if time-only values are provided as date and time literals?

1 Answers  

---

How to create and drop temp table in sql server?

1 Answers  

---

how will add additional conditions in sql?

1 Answers   Amdocs, Apps Associates,

---

What are the types of lock supported by ?

1 Answers   HCL,

---

What are rows and columns?

1 Answers  

---

What is the difference between function and stored procedure in sql server?

1 Answers  

---

How do you drop an index?

1 Answers  

---

what is a deadlock? : Sql server database administration

1 Answers  

---

what are different types of raid configurations? : Sql server database administration

1 Answers  

---

List the data types available in mssql?

1 Answers  

---