write the query for taking database backup in sql
Answer Posted / shardul negi
backup database <database name> to disk
= 'c:\<DatabaseName>.bak'
| Is This Answer Correct ? | 118 Yes | 25 No |
Post New Answer View All Answers
What is the report builder?
How does index makes search faster?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Name and describe few console utilities for ssrs?
What is the difference between Stored Procedures and triggers?
What is the difference function and stored procedure?
What is lock escalation and what is its purpose?
What is a non equi join?
Explain active/passive and active/active cluster configurations?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is a transactions?
Do you know how to send email from database?
Describe in brief databases and sql server databases architecture.
Does sql server use t sql?
What are the properties of sub-query?