write the query for taking database backup in sql

Answer Posted / prasant

It is working good but taking many time (Approx. 3 minutes for a 2gb database).

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create indexed view?

570


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

857


What stored by the model? : sql server database administration

537


How to get the query of a table in sql server?

494


How to define output parameters in stored procedures?

510






What is 3nf normalization form?

552


How to insert multiple rows with one insert statement in ms sql server?

582


What purpose does the model database server?

647


Explain concepts of analysis services?

503


What is @@rowcount in sql?

552


What do you mean by an execution plan? Why is it used? How would you view it?

523


When I delete any data from a table, does the sql server reduce the size of that table?

573


What is failover clustering overview?

581


What does sql server mean?

527


Explain raiserror in sql server?

567