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 blocking and how would you troubleshoot it?

3 Answers   HCL,

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

Explain query editor regions

0 Answers  

---

Difference between primary key and clustered index?

0 Answers  

---

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

---

What is the difference between a view and a stored procedure?

0 Answers  

---

What is the difference between varchar and nvarchar?

0 Answers  

---

Repair mdf file

2 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

What is subquery? Explain the properties of a subquery?

0 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---