如何导出 SQL Server 2008 数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15061712/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How can I export a SQL Server 2008 database?
提问by Dynamiite
Is it possible to export my database that i created in SQL Server 2008 Express?
是否可以导出我在 SQL Server 2008 Express 中创建的数据库？
I'm asking this because I need my group mate to be able to work on the same one. I know you can generate a script for the database but it give a bunch of errors when we try to run it.
我问这个是因为我需要我的队友能够在同一个团队中工作。我知道你可以为数据库生成一个脚本，但是当我们尝试运行它时会出现一堆错误。
回答by c0dem0nkey
You can right click the dbase then Task->Backup
This will generate a .bak file which you can
Task->Restore to a new database
您可以右键单击 dbase，然后单击 Task->Backup
这将生成一个 .bak 文件，您可以通过 Task->Restore to a new database
You can refer here http://msdn.microsoft.com/en-us//library/ms187048.aspx
你可以在这里参考 http://msdn.microsoft.com/en-us//library/ms187048.aspx
回答by FIFO BIZSOL
Yes. You can export your sqlserver database by using these steps.
是的。您可以使用这些步骤导出 sqlserver 数据库。
Right click on your database and hover on Tasks, you got another dropdown, Select Back Up.
You got a pop-up like this.
Click on OK button.
Navigate to path on your local PC (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\your database)
You got your exported database.
右键单击您的数据库并将鼠标悬停在任务上，您会得到另一个下拉菜单，选择备份。
你有一个这样的弹出窗口。
单击确定按钮。
导航到本地 PC 上的路径（C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\your database）
你得到了导出的数据库。
回答by Andrey Gordeev
Back it up on disk, give a copy of the file to your friend and tell him to restore a database from that copy.
将其备份到磁盘上，将文件的副本提供给您的朋友，并告诉他从该副本恢复数据库。
See this articlefor more help
请参阅此文章以获取更多帮助
回答by NiteshG86
Yes,export database from sql server 2008 express is possible.. create backup file and export it.
是的，可以从 sql server 2008 express 导出数据库.. 创建备份文件并将其导出。
