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.
| Author |
Topic |
|
todderamaa
Starting Member
1 Post |
 Posted - 2012-01-04 : 13:17:10
|
| Hello Everyone,I need to convert an SQL Server 2008 Database to Firebird.I have received a backup of the SQL Server Database. I need to restore the backup so that I can pump the data to Firebird.What tools do I need to purchase in order to Restore the database?I downloaded SQL Express and found out how to restore the database but get an error saying I have exceeded the file size limit. I am guessing the trial version only allows for a small database.Any help would be appreciated. I don't want to spend a fortune on SQL Server to do this conversion.ThanksTodd |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-04 : 13:26:17
|
| Cheapest would be a developer license (that's the full enterprise version, but not for commercial use - you'll need to check T&C's for whether your situation is OK or not)SQL Express limit is 4GB. When you restore a backup it pre-creates the database files to the size they were on the original server. It might be the original was 99% empty, in which case shrinking the original database, taking a new backup, and then restoring would work (assuming that original database shrinks to under 4GB total). The size of the Backup is not directly related to the size of the original files.Note that "SQL Server 2008 R2 Express" size limit is 10GB |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Restore Database and Licensing