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 are the types of containers in ssis?
Explain system functions or built-in functions? What are different types of system functions?
tell me the disaster recovery plan
What is 3nf normalization?
What is difference between clustered and non clustered index?
What is sql service broker?
Explain what is dbcc?
What is entity data services?
what does the automatic recovery do? : Sql server administration
Explain throw statement in sql server 2008?
Detail about query optimizer?
How do you migrate data from mssql server to azure?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Which is the main third-party tool used in sql server?
Is it important for a database administrator to understand the operating system and file access?