Open the sql server query analysiser To Type The following query Back

how to get the automatic backup of the database in the sql
server

Question Posted / kumar.t

Answer Posted / kumar.t

Open the sql server query analysiser

To Type The following query

Backup DataBase <DataBaseName>
To Disk ='Server path'

Is This Answer Correct ?

18 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What do you do in data exploration

1050

How can I know what locks are running on which resource?

994

What is model database? : SQL Server Architecture

1188

What is forward - only cursors / read only cursor?

1134

What is factless fact table? : sql server analysis services, ssas

1095

What extended events?

1062

What is the purpose of the model database?

1065

How do you rename a table in sql server?

1100

What do we need queues in sql service broker?

1121

What is the most common trace flags used with sql server?

1116

What are logical/boolean operations in ms sql server?

1101

What are the different types of cursor?

1149

Explain error handling in ssis?

1070

Can binary strings be used in arithmetical operations?

985

How to create a simple table to test triggers in ms sql server?

1034