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 is the difference between openrowset and openquery?

1077

How to create a scrollable cursor with the scroll option?

992

Define cross join in sql server joins?

1016

What is the difference between a primary key and a unique key? Are they the same?

1072

Define Wed Edition in SQL Azure?

100

How to rebuild all indexes on a single table?

1050

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

What is RMS migrations?

2128

What is sql server management studio? : sql server management studio

1065

How do I find information about the install locations for the various instances running on a computer?

1072

When to use null data driven subscription?

206

How do I install only the client tools of sql server 2000?

1061

How do we Backup SQL Azure Data?

108

When we should use and scope of @@identity?

995

What is cdc in sql server?

989