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

how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,


If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,


Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  


What is a transaction and what are ACID properties?

14 Answers   Virtusa, TCS, IBM, Config Systems,


what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  






Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  


Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  


Why Do you want to work in this company?

4 Answers   HCL,


how to rest identity columns in sql server

3 Answers   Matrix,


How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Symphony, TCS, Credit Suisse, GCU,


Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,


how to find nth highest salary

103 Answers   IBM, Oracle, Cognizant, NexGen,






Categories