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 are key constraints?

510


What are the different types of join?

560


What are the advantages of using third-party tools?

544


How many clustered indexes there can be on table ?

598


How to return the top 5 rows from a select query in ms sql server?

586






How can we delete Duplicate row in table?

630


How do I debug a stored procedure in sql server?

530


what is the difference between openrowset and openquery?

585


what is a correlated sub-query? : Sql server database administration

480


What are the differences between web role and worker role?

100


How to loop through result set objects using odbc_fetch_row()?

465


what are the reporting service components in SSRS?

118


What is instead of trigger sql server?

495


How to list all field names in the result set using mssql_field_name()?

522


How can you list all the columns in a database?

531