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 |
How do I view views in sql server?
What are the 7 disadvantages to a manual system?
What is the difference between ddl and dml?
ehat is the default port no of sql 2000?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to find the date and time of last updated table?
What are the properties of the relational tables?
What is the difference between a stored procedure and a user defined function in sql server?
Explain about nested stored procedure?
How to set the current database in ms sql server?
Write the syntax for stuff function in an sql server?
What is store procedure? How do they work? When do you use?