Search code examples
sqlsql-server-2008-express

How can I export a SQL Server 2008 database?

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.

Solution

  • 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