BACKUP DATABASE [db_SourceDbName] --SOURCE DB TO DISK = N'\\192.168

write the query for taking database backup in sql

Question Posted / madhu

10 Answers
36758 Views
ABC, IBM, Logica CMG, MA, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

36 Yes

21 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How connect excel to sql server?

983

How to insert a new row into a table with "insert into" statements in ms sql server?

958

What do you understand by SQL*Net?

1013

What is an execution plan? How would you view the execution plan?

1056

What is the difference between sdf and mdf?

1293

What is the importance of concurrency control?

1218

What do you mean by an execution plan?

1107

How to include date and time values in sql statements?

1077

Why I am getting this error when dropping a database in ms sql server?

1067

What is an inner join?

974

How to execute the cursor queries with "open" statements?

1172

Does the order of columns in update statements matter?

909

What is SQL Server?

1195

What are the new features in sql server 2016?

961

Who is the owner of a schema in ms sql server?

1067