write the query for taking database backup in sql

Answer Posted / shardul negi

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

Is This Answer Correct ?    118 Yes 25 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the properties of sub-query in sql server?

519


what is normalization? Explain different levels of normalization? : Sql server database administration

663


What is replication and database mirroring?

588


Define Business Edition in SQL Azure?

88


Difference between Inner vs outer joins?

541






Explain how you can configure a running aggregate in SSRS?

111


What is a print index?

508


How do we Backup SQL Azure Data?

86


What is the boxing and unboxing concept in .net?

558


List the various tools available for performance tuning?

490


Tell me what is de-normalization and what are some of the examples of it?

580


Do you know how to make remote connection in database?

561


tell me what is blocking and how would you troubleshoot it? : Sql server database administration

491


What is the return type of executeupdate ()?

533


How to recompile stored procedure at run time?

573