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 to transfer data from a cursor to variables with a "fetch" statement?
What is checkpoint process in the sql server?
What is tabulation?
Explain DBMS, RDBMS?
What stored procedure can you use to display the current processes?
What is single-user mode?
In which tcp/ip port does sql server run? Can it be changed?
Which Model uses the SET concept
How we can refresh the view?
Write a sql query to get zero records from a table having n number of records?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
0 Answers Amdocs, Apps Associates,
Give me a SQL Query to find out the second largest company?