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 is for xml in sql server?

0 Answers  


What are the events recorded in a transaction log?

0 Answers  


What are the different authentication modes in sql server?

0 Answers  


explain different types of constraints? : Sql server database administration

0 Answers  


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,


What are cursors?

8 Answers  


Explain the difference between functions and stored procedures in sql server?

0 Answers  


How to convert a numeric expression from one data type to another?

0 Answers  


what is the maximum size of sql row in mssql?

1 Answers  


What happens if null values are involved in bitwise operations?

0 Answers  


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  


What is the difference between indexing and hashing?

0 Answers  


Categories