write the query for taking database backup in sql
Answers were Sorted based on User's Feedback
Answer / shardul negi
backup database <database name> to disk
|Is This Answer Correct ?||118 Yes||25 No|
SQL Server 2000 BackUp Database,
backup database selvaa to disk = 'c:\selvaa.bak'
Processed 160 pages for database 'selvaa',
file 'selvaa_Data' on file 1.
Processed 1 pages for database 'selvaa', file 'selvaa_Log'
on file 1.
BACKUP DATABASE successfully processed 161 pages in 0.151
seconds (8.687 MB/sec).
|Is This Answer Correct ?||44 Yes||20 No|
Answer / madhu
[db_SourceDbName] --SOURCE DB
TO DISK = N'\\192.168..124\db_TragetDbName.BAK' -- LOCATION
NAME = N'myDbFull Backu[p-Full Database Backup',
STATS = 10
|Is This Answer Correct ?||36 Yes||21 No|
Answer / vinod
its really working good
|Is This Answer Correct ?||19 Yes||9 No|
Answer / purav topiwala
Backup database (your database name) to disk="(location
where back will store)"
|Is This Answer Correct ?||12 Yes||6 No|
Answer / christopher issac
|Is This Answer Correct ?||13 Yes||9 No|
Answer / hemant pal
backup database northwind to disk = 'c:\northwind.bak'
|Is This Answer Correct ?||11 Yes||10 No|
Answer / stephen tharkey
I think it is better but still need improvement.
|Is This Answer Correct ?||6 Yes||7 No|
Answer / kishore
|Is This Answer Correct ?||8 Yes||10 No|
Answer / prasant
It is working good but taking many time (Approx. 3 minutes for a 2gb database).
|Is This Answer Correct ?||1 Yes||3 No|
What are the different editions available in sql server 2000?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
What are the advantages of using sql server over ms access or why should one use sql instead of ms access
Tell about MOM Tool(Microsoft Operator Manager)?
Can you get second highest salary from the table?
What is Transparent Data Encryption?
How will you make an attribute not process? : sql server analysis services, ssas
What is the difference between lock, block and deadlock? : sql server database administration
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
Can we return Data from 4(more than 1) tables in stored procedure?
What is the purpose of sql profiler in sql server? : sql server database administration