write the query for taking database backup in sql

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / samplestudy

10 Answers
35334 Views
ABC, IBM, Logica CMG, MA, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write the query for taking database backup in sql..

Answer / shardul negi

backup database <database name> to disk
= 'c:\<DatabaseName>.bak'

Is This Answer Correct ?

118 Yes

25 No

write the query for taking database backup in sql..

Answer / selvaraj.v

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

write the query for taking database backup in sql..

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

write the query for taking database backup in sql..

Answer / vinod

its really working good

Is This Answer Correct ?

19 Yes

9 No

write the query for taking database backup in sql..

Answer / purav topiwala

Backup database (your database name) to disk="(location
where back will store)"

Is This Answer Correct ?

12 Yes

6 No

write the query for taking database backup in sql..

Answer / christopher issac

Super!..working properly...

Is This Answer Correct ?

13 Yes

9 No

write the query for taking database backup in sql..

Answer / hemant pal

backup database northwind to disk = 'c:\northwind.bak'

Is This Answer Correct ?

11 Yes

10 No

write the query for taking database backup in sql..

Answer / stephen tharkey

I think it is better but still need improvement.

Is This Answer Correct ?

6 Yes

7 No

write the query for taking database backup in sql..

Answer / kishore

great solution....!!!

Is This Answer Correct ?

8 Yes

10 No

write the query for taking database backup in sql..

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

Post New Answer