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

write the query for taking database backup in sql

Question Posted / hemant pal

Answer Posted / hemant pal

Is This Answer Correct ?

11 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How many triggers are possible per table?

1090

What is set nocount on?

932

What are the indexes in sql server?

1107

What are system databases into sql server (2005/2008)?

993

How to test odbc dsn connection settings?

1015

What are the default system databases in sql server 2000?

1019

What stored by the master?

944

What are the different types of normalization?

1157

What are the different types of lock modes in sql server 2000?

936

How do you delete duplicate rows in sql server?

951

how to use DTS package in 2000,2005,2008 in sql server

1828

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1019

How do you check sql server is up and running?

987

When would you use the stored procedures or functions?

998

What do you understand by physical_only option in dbcc checkdb?

973