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
What are the two authentication modes in sql server?
List some advantages and disadvantages of stored procedure?
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?
What is data set in report?
What is a subquery in a select query statement in ms sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
Is truncate a dml command?
Tell me what is sql profiler?
How to return the date part only from a sql server datetime datatype?
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?
Is it important for a database administrator to understand the operating system and file access?
What do you think of this implementation? Can this be implemented better?
How can you check the version of sql server?
When columns are added to existing tables, what do they initially contain?
Equi join and non equi join is possible with sql server?