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.

score 12 · Accepted Answer · answered Feb 25 '13 at 07:08

12

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

answered Feb 25 '13 at 07:08

c0dem0nkey

616
4
13

or connect to a common server via IP – c0dem0nkey Feb 25 '13 at 07:09
Im getting an error saying " The database was backed up on a server tunning 10.50.4000. That version is incompatible with this server, which is running 10.00.2531 – Dynamiite Feb 25 '13 at 07:21
1

ok. looks like you're running SQL 2008 R2 and your friend is running just SQL2008. SQL has no backward compatibility. – c0dem0nkey Feb 25 '13 at 07:24

score 5 · Answer 2 · edited Apr 22 '13 at 09:13

5

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

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.

edited Apr 22 '13 at 09:13

Andrew Barber

39,603
20
94
123

answered Apr 19 '13 at 20:47

FIFO BIZSOL

729
6
6

score 0 · Answer 3 · answered Feb 25 '13 at 07:07

0

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 article for more help

answered Feb 25 '13 at 07:07

Andrey Gordeev

30,606
13
135
162

There must be an easier way – Dynamiite Feb 25 '13 at 07:08
@Sebastian no, I don't think so – Andrey Gordeev Feb 25 '13 at 07:09

score 0 · Answer 4 · answered Feb 25 '13 at 07:08

0

Yes,export database from sql server 2008 express is possible.. create backup file and export it.

answered Feb 25 '13 at 07:08

NiteshG86

85
1
8

How can I export a SQL Server 2008 database?

4 Answers4