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
Explain transaction server auto commit?
What is single-user mode?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Explain what you mean by 3 tier architecture.
What is a subquery in a select query statement in ms sql server?
What is importing utility?
How to drop an existing stored procedure in ms sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
What is store procedure? How do they work?
What is the benefit of normalization?
How to Update from select query in sql server?
What is rolap and its advantage? : sql server analysis services, ssas
How to skip remaining statements in a loop block using continue statements?
What are the different types of upgrades that can be performed in sql server?
What is the recovery model? List the types of recovery model available in sql server?