write the query for taking database backup in sql

Answer Posted / hemant pal

backup database northwind to disk = 'c:\northwind.bak'

Is This Answer Correct ?    11 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the two authentication modes in sql server?

600


List some advantages and disadvantages of stored procedure?

560


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

512


What is data set in report?

95


What is a subquery in a select query statement in ms sql server?

584






How to transfer an existing table from one schema to another schema in ms sql server?

508


Is truncate a dml command?

499


Tell me what is sql profiler?

619


How to return the date part only from a sql server datetime datatype?

573


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

553


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

506


What do you think of this implementation? Can this be implemented better?

531


How can you check the version of sql server?

559


When columns are added to existing tables, what do they initially contain?

627


Equi join and non equi join is possible with sql server?

483