How to take backup of database from server explorer

Question

0.00/5 (No votes)

See more:

Hello Every one

I want to know how to take back up of Database from server explorer of Visual studio 2010
I know how to take it from sql management studio but not from server Explore

Plz provide solution as quick as possible

Thnak you

Posted 14-Oct-13 23:52pm

A.Girish

Add a Solution

3 solutions

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)

R. Ramprakash · Answer 1 · 2013-10-15T02:25:00

Solution 1

In Sql server management studio 2008 go to Object explorer->right click the database you want to take backup-> Tasks-> Backup

If you want to get all the index, structure, etc etc then right click the Database-> Tasks-> Generate Scripts.

It will simplify your work :)

Posted 15-Oct-13 2:25am

R. Ramprakash

Comments

A.Girish 15-Oct-13 23:50pm

I'm using Sql express for creating tables and database i need process for sql server express

Dipesh Wadhwa · Answer 2 · 2013-10-18T01:39:00

Solution 3

You cant take backup from Server Explorer in Visual Studio.

What you can do is, follow the following steps:
1. Open Server Explorer.
2. Close the connection of Database Object for which you want to take backup.
3. Open Sql Management Studio, attach your Desired Database (In-Case not attached).
3. Take Back-Up by right click database.
4. Now de-attach the database from Sql Management Studio and again use in Visual Studio by Opening Connection.

Posted 18-Oct-13 1:39am

Dipesh Wadhwa

Comments

A.Girish 21-Oct-13 0:20am

Dude how can attach database in sqlexpress to SQL management studio. Sql Express it doesn't showing any options for backup

Dipesh Wadhwa 21-Oct-13 0:56am

Check the following links, this will help you in ATTACHING & DE-ATTACHING DATABASE FILE in SQL EXPRESS.
http://technet.microsoft.com/en-us/library/ms190209.aspx

http://technet.microsoft.com/en-us/library/ms165673%28v=sql.105%29.aspx

http://blogs.msdn.com/b/bethmassi/archive/2008/12/18/attaching-a-local-sql-express-database-using-sqlcmd.aspx

JaRoLLz · Answer 3 · 2015-07-14T21:44:00

Solution 4

It's impossible to backup from VS.

If in the connectionString you use something like (localdb)\v11.0 etc then, you can use it directly as server name in SSMS and connect to it directly. You'll see all your projects db then. After that you can backup.

Posted 14-Jul-15 21:44pm

JaRoLLz

Updated 15-Jul-15 7:58am

v2

Comments

CHill60 15-Jul-15 7:13am

This is a not a solution to this 2 year old problem!

JaRoLLz 15-Jul-15 13:57pm

Sorry, from the previous answer it seems as if it's already established that visual studio SQL server object explorer has no backup capability. And I think I missed other solutions except no 3 that says about attaching the db to a connected server in SSMS, whereas it's not needed, but just use the "proper" server name as written in web.config to see the DB in SSMS. Now, after seeing the DB in SSMS, the main purpose of making backup of the DB can be done.