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

What are the advantages of using stored procedures?

951

---

can a database be shrunk with users active? : Sql server administration

1011

---

When is update_statistics command used?

1046

---

Explain about SQLOS?

1013

---

What is resultset concur_updatable?

1021

---

How do you create a clustered index?

1056

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

1041

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1958

---

What is Cross Join and in which scenario do we use Cross Join?

1013

---

Describe the left outer join & right outer join. : sql server database administration

997

---

What is the temp table?

924

---

What is create command?

974

---

what are the core components of SSRS?

129

---

How to concatenate two strings in SQL Server.

1149

---

What is user-defined multi-statement table-valued function?

1065

---