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 DAC? what is the use of it?

1 Answers   Wipro,

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

---

What is thr feature of change data capture?

0 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---

---

What does normalization do to data?

0 Answers  

---

How to update muliple row in single query?

0 Answers   MCN Solutions,

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

What is the sql case statement used for? Explain with an example?

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

Describe in brief sql server monitoring ways.

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---