Is there a way to take a backup file from SQL Server Express Edition and restore it into a standard SQL Server database? I tried to do it from Management Studio but it didn't recognize the file format.
A:
Yes. It should work using the standard tools. What versions of the databases are you working with?
Ken
2008-10-02 17:26:05
I think I know why I encountered a problem. I'm using SQL Server 2005 Express Edition, but the standard version of SQL Server that I tried to import into is SQL Server 2000.
2008-10-03 12:37:36
+1
A:
If you have a databse .bak file you can move from SQL Server 2005 Express to SQL Server.
Just make sure that you check the option to overwrite the existing DB.
Mitchel Sellers
2008-10-02 20:06:11