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
Why do we need different type of parameter?
What is a database in ms sql server?
Can you explain full-text query in sql server?
What are partitioned views?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
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.
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is sub query and its properties?
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?
Explain raiserror in sql server?
What is transaction server implicit?
Why are you getting errors when creating a new odbc dsn?
What is the xml datatype?
What is inner join in sql server joins?
Explain what are the basic functions for master, msdb, model, tempdb databases?