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 are number line correlation administrators will use while working with a subquery?

0 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

---

How can a database be repaired?

0 Answers  

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

Can we call stored procedure in trigger?

0 Answers  

---

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

Define inner join? Explain with an example?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

Can we write trigger for view?

0 Answers  

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

difference between truncate, delete aur drop?

2 Answers  

---