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 the phases a transaction has to undergo?

973

---

Explain relational data?

931

---

How many non clustered indexes there can be on table ?

927

---

Explain what are commit and rollback in sql?

941

---

What is the order by used for?

1032

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

949

---

What is a covering index?

993

---

How to implement service broker?

1025

---

How to call a function from a stored procedure in SQL Server ?

1038

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1090

---

How to Insert multiple rows with a single insert statement?

1062

---

How do I find the sql server version?

1036

---

Define candidate key, alternate key, and composite key.

931

---

What happens if the update subquery returns no rows in ms sql server?

1134

---

How will you optimize a stored procedure optimization?

1052

---