backup database <database name> to disk = 'c:\<DatabaseName

write the query for taking database backup in sql

Question Posted / shardul negi

Answer Posted / shardul negi

backup database <database name> to disk
= 'c:\<DatabaseName>.bak'

Is This Answer Correct ?

118 Yes

25 No

Please Help Members By Posting Answers For Below Questions

Is it possible to call a stored procedure within a stored procedure?

955

What is a trigger? Why we need it?

990

Explain full-text indexing?

971

What are a scheduled jobs?

952

How to change the data type of an existing column with "alter table" statements in ms sql server?

976

What is bcp? When does it use?

935

How can we rewrite sub-queries into simple select statements or with joins?

969

What are the extra roles available in msdb? : sql server security

1123

Explain microsoft sql server functions?

1099

How to convert a table data in XML format in sql server?

2531

What do you understand by integration services in sql server?

955

What are cursors in ms sql server?

1169

Why do we need normalization?

919

What is self contained multi valued query?

1006

How to replace the Query Result 'Null Value' with a text ?

1025