write the query for taking database backup in sql




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

What are the different editions available in sql server 2000?

0 Answers  


Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  


What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   Impetus, CMS,


Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  


Can you get second highest salary from the table?

0 Answers   QuestPond,






What is Transparent Data Encryption?

0 Answers  


How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  


What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  


how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,


in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  


Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,


What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  






Categories