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

What are the tools available in market as an alternative to sql server reporting services?

121

Describe and explain about SQL native client?

1043

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

What is history table in sql server?

905

What are the advantages of sql azure?

140

What is tabulation?

902

How to generate create function script on an existing function?

1054

Why functions are used in sql server?

906

Explain about nested stored procedure?

985

What is data source view or dsv? : sql server analysis services, ssas

954

What is report server project?

137

How to stop a loop early with break statements in ms sql server?

984

How to recover from sql injection? : sql server security

966

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

932

How to link tables in sql server?

896