I know I can 'attach' a .mdf sql express database. However, is there a way to convert the file format into a regular sql express database? Will "restore" work on a .mdf?
Backup/restore should just work fine if you are using a SQL Server Express version which is at least the same version. Using advanced features could also prevent to downgrade to SQL Server Express. It can be checked using
http://technet.microsoft.com/en-us/library/cc280724(v=sql.100).aspx
Edit: not sure what you meant with "Will 'restore' work on a .mdf?". You won't restore directly a mdf file. You'll use first the "backup" statement to create a SQL Server backup file and then you'll use this backup file for your "restore" statement...
Member
137 Points
846 Posts
How do I convert a .mdf "file format" database to a regular SQLExpress database
Feb 25, 2014 04:30 PM|codeaholic|LINK
I know I can 'attach' a .mdf sql express database. However, is there a way to convert the file format into a regular sql express database? Will "restore" work on a .mdf?
All-Star
43240 Points
14959 Posts
Re: How do I convert a .mdf "file format" database to a regular SQLExpress database
Feb 25, 2014 05:40 PM|PatriceSc|LINK
Hi,
Backup/restore should just work fine if you are using a SQL Server Express version which is at least the same version. Using advanced features could also prevent to downgrade to SQL Server Express. It can be checked using http://technet.microsoft.com/en-us/library/cc280724(v=sql.100).aspx
Edit: not sure what you meant with "Will 'restore' work on a .mdf?". You won't restore directly a mdf file. You'll use first the "backup" statement to create a SQL Server backup file and then you'll use this backup file for your "restore" statement...