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

How to list all stored procedures in the current database using ms sql server?

811


How we create SQL Server 2005 Reporting Services ? Give me Sample

1738


List out the differences between the clustered index and non-clustered index in sql server?

700


How to connect a database with sql express.?

750


How to generate random numbers with the rand() function in ms sql server?

758






I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

815


What are scheduled tasks in sql server?

731


How to get nth highest salary from employee table.

791


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

792


How can we delete Duplicate row in table?

790


What is partition, how will you implement it? : sql server analysis services, ssas

795


How to loop through returning rows?

737


In case you have filters in your report, when filters will be applied in cached report instance?

91


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

700


What is a covering index?

719