how to take the DB backup from online database by using Sql server 2008

Question

5.00/5 (1 vote)

See more:

SQL-Server-2008

, +

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 2:48am

genious Developer

Updated 19-Sep-11 20:01pm

v4

Add a Solution

Comments

Corporal Agarn 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 17-Sep-11 4:45am

i have administrator rights

genious Developer 17-Sep-11 11:10am

database is existing on hosting server.

genious Developer 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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mehdi Gholam · Answer 1 · 2011-09-16T02:59:00

Solution 1

Use the following tsql to backup your database :

SQL

Backup database [database name] to disk=’\\servername\path.bak’

Posted 16-Sep-11 2:59am

Mehdi Gholam

Comments

Mehdi Gholam 17-Sep-11 11:33am

Check with your service provider what path you have access to?

Mehdi Gholam 20-Sep-11 1:21am

What is the error message you are getting?

Mehdi Gholam 20-Sep-11 11:45am

c:\backup\ does not exist, use a path that exists.

genious Developer 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 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 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 20-Sep-11 12:57pm

download via ftp

genious Developer 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