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

What are the types of containers in ssis?

603


Explain system functions or built-in functions? What are different types of system functions?

567


tell me the disaster recovery plan

2025


What is 3nf normalization?

568


What is difference between clustered and non clustered index?

531






What is sql service broker?

588


Explain what is dbcc?

595


What is entity data services?

578


what does the automatic recovery do? : Sql server administration

538


Explain throw statement in sql server 2008?

581


Detail about query optimizer?

612


How do you migrate data from mssql server to azure?

151


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

867


Which is the main third-party tool used in sql server?

478


Is it important for a database administrator to understand the operating system and file access?

512