如何从服务器资源管理器中备份数据库 [英] How to take backup of database from server explorer

问题描述

Hello Every each



我想知道如何从Visual Studio 2010的服务器资源管理器中恢复数据库

我知道如何从sql管理工作室而不是从服务器上获取它探索



Plz尽可能快地提供解决方案



Thnak you

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

推荐答案

在Sql server management studio 2008中，转到Object explorer->右键单击要备份的数据库 - >任务 - >备份





如果你想获得所有的索引，结构等，那么右键单击Database->任务 - >生成脚本。



它将简化您的工作：）

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 :)

您无法从Visual Studio中的服务器资源管理器中获取备份。



你可以做的是，按照以下步骤：

1.打开服务器资源管理器。

2.关闭要备份的数据库对象的连接。

3.打开Sql Management Studio，附加所需数据库（未附加案例）。

3.通过右键单击数据库进行备份。

4.现在从Sql Management Studio中取消附加数据库，然后再通过Open Connection在Visual Studio中使用。

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.

从VS备份是不可能的。



如果在connectionString中使用类似（localdb）\v11.0等的东西，那么你可以直接在SSMS中将其用作服务器名称并直接连接到它。然后，您将看到所有项目数据库。之后你可以备份。

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.

这篇关于如何从服务器资源管理器中备份数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！