Answer Posted / madhu

BACKUP DATABASE
[db_SourceDbName] --SOURCE DB
TO DISK = N'\\192.168..124\db_TragetDbName.BAK' -- LOCATION
FILE NAME
WITH
NOFORMAT,
NOINIT,
NAME = N'myDbFull Backu[p-Full Database Backup',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10
GO

Tell me about the approaches which you used to counter the DI problems.

1287

---

What are the advantages of using a stored procedure?

959

---

What is attribute hierarchy? : sql server analysis services, ssas

977

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1101

---

What is tablix?

156

---

What are the database objects? : SQL Server Architecture

1002

---

How to create a Master database in SQL server ?

1039

---

What are the system database in sql server 2005?

996

---

why would you use sql agent? : Sql server database administration

1134

---

What is mean by candidate key?

959

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

942

---

What is the web service used for reporting services?

116

---

How do we know if any query is retrieving a large amount of data or very little data?

931

---

How do I install only the client tools of sql server 2000?

1003

---

How to scale out a federation by Sql statement?

116

---