How can I export a SQL Server 2008 database?

sql sql-server-2008-express
Dynamiite picture Dynamiite · Feb 25, 2013 · Viewed 30k times · Source

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

c0dem0nkey picture c0dem0nkey · Feb 25, 2013

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

Related questions

Sql connection-string for localhost server

I am newbie in this .NET and please don't mind in answering my simple question. I am trying to write a windows application, where in I am using a localhost SQLserver for database. I need to know what is the …

Read More
An explicit value for the identity column in table 'customers' can only be specified when a column list is used and IDENTITY_INSERT is ON

Possible Duplicate: Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF I am new to SQL. I am trying to write a INSERT query in SQL server 2008 Express edition. The query is : …

Read More
How to find the worst performing queries in SQL Server 2008?

How to find the worst performing queries in SQL Server 2008? I found the following example but it does not seem to work: SELECT TOP 5 obj.name, max_logical_reads, max_elapsed_time FROM sys.dm_exec_query_stats a CROSS …

Read More