Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Attaching a Database

Author  Topic 

JayatBMC
Starting Member

1 Post

Posted - 2010-10-12 : 10:48:38
Hi,

Is it possible to attach a database file in SQL server express if the database itself was created with a non express version of SQL server?

We have had a dispute with a company that had provided us with a software package wherein the data was stored on a database on their server. As part of the resolution of the dispute we asked for and they have agreed to give us a copy of the data that was collected for the year or so that we used their product.

They want to provide us with the SQL server file that has the data in it and have told us that we will be able to read it with the Express edition of SQL server. I don't have any significant experience with SQL server.

Are there any potential problems that we might run into in this scenario?


Thanks for any help.

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2010-10-18 : 11:00:03
I don't know of any issues but look at the following:

http://msdn.microsoft.com/en-us/library/ms165673.aspx



Terry

-- You can't be late until you show up.
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-18 : 14:38:23
Providing the database isn't over the size limit of express, should be no problems.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -