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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SQL Server?

670


What is a schema in ms sql server 2005?

575


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3769


How will you make an attribute not process? : sql server analysis services, ssas

594


How to start and end transact-sql statements?

592






What is the difference between resultset and resultsetmetadata?

527


What is precedence constraint?

552


can any body tell me how to know the password of current user in sql server

1589


What is the contrast between sql and pl/sql?

629


How to create new table with "create table" statements?

575


how you can move data or databases between servers and databases in sql server? : Sql server administration

493


What is the difference between clustered and a non-clustered index?

601


How to perform backup for certificates in sql server? : sql server security

603


How to create median function?

118


Do you know sql server 2008 introduces automatic auditing?

528