Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
do any one know how to take the DB backup from online database
for MSSQL 2008 R
I tried but no luck
I had SQL Server Managment Studio
to update and edit manualy @ DB
 

Some one told me i need to dump database first by using sql query then make backup but i donot know the procedure how i do that.please help me out in detail if any one knows asap thanks
 

database backup is created on the server easily.but i need to make is on local disk.so i am unable to create backup on local disk.i try 2 to 3 quries but no query work.so plz help me out.
if first i need to dump database then how can i dump any procedure plz help me out
Posted 16-Sep-11 3:48am
Edited 19-Sep-11 21:01pm
v4
Comments
djj55 at 16-Sep-11 9:21am
   
What permissions do you have? Note that at the top of the dialog window there is an icon for Script. Click this and let us know the result. Mehdi Gholam's solution should work though.
genious Developer at 17-Sep-11 4:45am
   
i have administrator rights
genious Developer at 17-Sep-11 11:10am
   
database is existing on hosting server.
genious Developer at 20-Sep-11 1:16am
   
dear database backup is created on the server easily.but i need to make is on local disk.so i am unable to create backup on local disk.i try 2 to 3 quries but no query work.so plz help me out.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Use the following tsql to backup your database :
Backup database [database name] to disk=’\\servername\path.bak’
  Permalink  
Comments
Mehdi Gholam at 17-Sep-11 11:33am
   
Check with your service provider what path you have access to?
Mehdi Gholam at 20-Sep-11 1:21am
   
What is the error message you are getting?
Mehdi Gholam at 20-Sep-11 11:45am
   
c:\backup\ does not exist, use a path that exists.
genious Developer at 20-Sep-11 12:09pm
   
what does it mean dear.
the server path is
F:\MS SQL\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Backup-hsnaamir_mobiles.bak
 
but i need to make backup on local disk.
so i put this
C:\Backup\Backup-hsnaamir_mobiles.bak
 
if it is wrong then what path i should provide for backup on my local disk
Mehdi Gholam at 20-Sep-11 12:49pm
   
you cannot backup to local path directly, you must backup to the server then transfer the file to your local computer
genious Developer at 20-Sep-11 12:52pm
   
i make backup on server successfull so now how i transfer it on local disk plz guide me
Mehdi Gholam at 20-Sep-11 12:57pm
   
download via ftp
genious Developer at 5-Oct-11 5:49am
   
plz help me out there thanks
 
http://www.codeproject.com/Questions/263750/user-can-download-one-file-without-login-but-how-p

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

  Print Answers RSS
0 OriginalGriff 505
1 Maciej Los 309
2 BillWoodruff 174
3 /\jmot 160
4 Suraj Sahoo | Coding Passion 160
0 OriginalGriff 8,654
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,639
3 Maciej Los 5,229
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 20 Sep 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100