Click here to Skip to main content
15,906,097 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
hai Seniors..

can anybody tel me code to backup db from server.. i process authentication credentials for server access. i need to restore it to the local sql also..

am new to this and also tell me whether sql sever provides any function to make my job..

Thank you.....
Posted

I understood your problem now.

I found Transferring backup files from a remote SQL Server instance to a local machine without network shares, FTP, HTTP[^] after googling for 1 hr. It is a very good artcle which will help you.

Another link- database-backup-to-restore-from-remote-server-sql-server[^], which is just a manual process of taking back-up with the help of SQL Server Management Studio just for your reference.
Thanks...
 
Share this answer
 
Comments
Please accept the answer so that it will help others in finding the solution with one go and it will not be in the "Unanswered" list.
Thanks.
Check this StackOverflow Link[^].
It has an accepted answer.
 
Share this answer
 
Comments
anish.karunakaran 17-Jul-12 6:16am    
Haii.. The Link is Related to Server Side Backup of SQL DB, not to a Local PC.

Can any body help me get out this riddle
What do u exactly mean by local PC back-up ?
What u want to do ?
anish.karunakaran 30-Jul-12 0:09am    
@Tadit : Haii.. What my need is to take backup of the remote db in sql server express to my local PC. With Database backup we can only take backup to the server machine itself but my need is to transfer that backup file to my local PC and restore it with the DB in My Local SQL Server.

Thank you..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900