how to take sql database backup from sever

Posted by Parthibansk under Sql Server on 2/5/2014 | Points: 10 | Views : 675 | Status : [Member] | Replies : 3
unable to take sql db backup from server using query..

is any network settings prompting?

guide me in this regard




Responses

Posted by: Satyapriyanayak on: 2/5/2014 [Member] [MVP] Silver | Points: 25

Up
0
Down
http://stackoverflow.com/questions/3942207/how-to-backup-remote-sql-server-database-to-local-drive


If this post helps you mark it as answer
Thanks

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/7/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
http://www.wikihow.com/Back-Up-an-SQL-Server-Database-Using-Transact-SQL
http://stackoverflow.com/questions/3741846/query-for-backup-a-database-at-another-location-in-file-system
http://www.mssqltips.com/sqlservertutorial/20/sql-server-backup-database-command/

Revert me back if this is not working for your scenario.

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sravan661 on: 2/7/2014 [Member] Bronze | Points: 25

Up
0
Down
Hi,
Full database backup using a BACKUP DATABASE statement.
http://technet.microsoft.com/en-us/library/ms191304%28v=sql.105%29.aspx

here you can see how to take backup from sql server management studio.
http://technet.microsoft.com/en-us/library/ms187510.aspx

if you tried the same let us know what error you are getting
revert if you have issues



sravan

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response