write the query for taking database backup in sql

Answer Posted / purav topiwala

Backup database (your database name) to disk="(location
where back will store)"

Is This Answer Correct ?    12 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do I need to start working with sql studio? : sql server management studio

593


What are different types of subquery?

721


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

562


What do we have to check in database testing?

585


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

506






how many triggers you can have on a table? : Sql server database administration

497


System requirements for sql server 2005 express edition?

569


When we should use and scope of @@identity?

548


Does a sql server 2005 select statement require a from?

580


List the different types of joins?

569


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

535


What is transaction server auto commit?

579


How much memory that we are using in Logshipping Concept?

1368


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

501


Explain how many normalization forms?

581