How can I export a SQL Server 2008 database?

Question

Is it possible to export my database that i created in 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.

Answer 1

You can right click the dbase then Task->Backup
This will generate a .bak file which you can Task->Restore to a new database

You can refer here http://msdn.microsoft.com/en-us//library/ms187048.aspx

Answer 2

Yes. You can export your sqlserver database by using these steps.

1. Right click on your database and hover on Tasks, you got another dropdown, Select Back Up.

2. You got a pop-up like this.

3. Click on OK button.

4. Navigate to path on your local PC (C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\your database)

5. You got your exported database.