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
= 'c:\<DatabaseName>.bak'
Is This Answer Correct ? | 118 Yes | 25 No |
SQL Server 2000 BackUp Database,
Query:
------
backup database selvaa to disk = 'c:\selvaa.bak'
Answer:
-------
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
BACKUP DATABASE
[db_SourceDbName] --SOURCE DB
TO DISK = N'\\192.168..124\db_TragetDbName.BAK' -- LOCATION
FILE NAME
WITH
NOFORMAT,
NOINIT,
NAME = N'myDbFull Backu[p-Full Database Backup',
SKIP,
NOREWIND,
NOUNLOAD,
STATS = 10
GO
Is This Answer Correct ? | 36 Yes | 21 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 / 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 / prasant
It is working good but taking many time (Approx. 3 minutes for a 2gb database).
Is This Answer Correct ? | 1 Yes | 3 No |
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
how to get 25th row in any table in sqlserver can u tell me syntax
What is instead of trigger sql server?
Define cross join in sql server joins?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Is the log file is a part of file group?
Write a SQL Query to find first Week Day of month?
Explain filestream storage of sql server 2008?
Explain the disadvantages of cursors?
What is a join in sql? What are the types of joins?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?