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


Please Help Members By Posting Answers For Below Questions

Why do we need different type of parameter?

550


What is a database in ms sql server?

556


Can you explain full-text query in sql server?

554


What are partitioned views?

584


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

551






Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1429


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

584


What is sub query and its properties?

549


You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

99


Explain raiserror in sql server?

579


What is transaction server implicit?

536


Why are you getting errors when creating a new odbc dsn?

593


What is the xml datatype?

630


What is inner join in sql server joins?

549


Explain what are the basic functions for master, msdb, model, tempdb databases?

533