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 do mean by xml datatype?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

What is correlated subquery in sql server?

0 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

What is resultset concur_updatable?

0 Answers  

---

Explain the first normal form(1nf)?

0 Answers  

---

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

---