Restoring from a SQL 2008 Backup

As a new customer, will I have the opportunity to launch a new site from a VS 2010 publish and to upload a current backup of the SQL 2008 database the application requires.

I have been told by a Sales Engineer that your SQL Tools may or may not support a backup created from my specific edition of SQL Server.

Before I take the plunge, I would like some form of verification on this subject.

The current database has a compatibility of SQL 2008 (100) and is hosted on a server running server version 10.0.2531.

If it matters, the database supports nopCommerce 1.7 and the application is running ASP.Net 4.0.

Thanks in advance for your help.

 

Our SQL Tools will allow you to attach the MDF which is what I think you're using locally, as you're probably using SQL Express.

Although if you're that version, make sure you get the SQL 2008 R2 database, as you cannot restore it onto a SQL 2008 (non-R2).

Should be fine however, and there shouldn't be any problems.

 

Jose,

I am not using SQL Express, I currently have a development environment with a standalone version of SQL Server 2008. I think it is non-R2, and I think it does not have the latest service packs applied to it.

I can perform a detach of the database and manually upload the .mdf/.ldf if that is what you are suggesting.

Am I understanding all of this correctly?

 

I'd recommend using your local SQL Server environment and making a backup file (BAK) and then using that to restore to our SQL server. It's probably the best approach as it has the least amount of 'unforseen' problems.

Otherwise you can upload the MDF of your database (no LDF, sorry) and just attach it to the server.

 

The backup seems to have worked perfectly, thanks Jose.