write the query for taking database backup in sql

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

Question Posted / samplestudy

10 Answers
36870 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

More SQL Server Interview Questions

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers AllState,

What is a NOLOCK?

3 Answers NA,

How do you read transaction logs

1 Answers

Mention the command used to rename the database.

0 Answers

What is a join in sql?

0 Answers

What are pages and extents? : SQL Server Architecture

0 Answers

What is SQL Profiler and the use of it?

2 Answers 247Customer,

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers

How many types of attribute relationships are there? : sql server analysis services, ssas

0 Answers

Explain the architecture of SQL Server?

2 Answers ABC, HP, Oracle,

What is single-user mode?

0 Answers

For more SQL Server Interview Questions Click Here