Neale
Reputation: 463
SQL express 2008 restore from a SQL Server 2008 backup
I have done some research online but i cant seem to find a proper answer. I am trying to restore a SQL server 2008 backup onto a sql express 2008 system (Live environment backup to Development environment)
The problem is i keep getting a "SQL Server cannot process this media family" error code 3241.
Any ideas???
Thanks
Upvotes: 2
Views: 1901
Answers (1)
Hemant Tank
Reputation: 1744
A simple solution would be to create a script of the DB and then run it on an empty database of the same name.
Ref: http://www.devx.com/dbzone/Article/40531
Upvotes: 1
Related Questions
- Create/restore database from backup SQL Server Express
- Migration MSSql Db - from SQL Server 2008 R2 Enterprise backup can restore in SQL Server 2008 R2 Express version
- How can I restore a database in SQL Server 2012 from SQL Server 2012 Express?
- Can we restore backup from SQL Server 2008 R2 to SQL Server 2008 R2 Express Edition?
- Backup and Restore from SQL Server 2005 to 2008 express edition?
- Can we restore database backup of SQL Server 2008 R2 Express to SQL Server 2008 Express
- Restore a SQL Express database from a file backup
- c# express back up/restore database
- Cannot restore backup on SQL Server Express
- Restoring a SQL Server Express Edition Database