Last post Feb 25, 2014 05:40 PM by PatriceSc
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?
Feb 25, 2014 05:40 PM|PatriceSc|LINK
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
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...