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

Explain having clause and where clause?

1055

Explain filestream storage of sql server 2008?

1016

What are the acid properties?

1005

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

905

What are statistics?

997

How to add a new dsn with the odbc driver for sql server?

1060

What are Row versions of DataRow?

1028

Why is sql server log file full?

1034

Write an SQL query to obtain the 2nd highest salary.

1078

What is the difference between dropping a database and taking a database offline?

1172

how you can list all the tables in a database?

1026

Is there any difference between the primary key and unique key?

999

What happens to a statement batch if there is a compilation error?

966

What are the properties of the transaction?

1004

What is table level trigger?

1020