Working without SQL Express on standalone


Hello everyone,

Today I will talk about restoring the database. When you want to debug an application it is sometimes necessary to reproduce exactly the same environment as production. But then if we develop on a “standalone” machine, we can face a message like:

The Database was backed up on a server running version XXXXXX. That version is incompatible with this server, which is running version YYYYYY

Where YYYYY is smaller than XXXX. And even if we did all available updates!

The reason is, by default when installing a “standalone” version of SharePoint, even if we have installed a SQL Server before you install SharePoint, it installs the SharePoint databases in a SQL Express instance!

And therefore, can not restore a backup database from a production SQL Server that is not SQL Express.

To avoid this, there is a small tip.

When installing SharePoint in “standalone”, it will seek a default SQL instance named”SharePoint”, and if he does not find it, he created it on SQL Express!

To avoid this, when installing SQL Server on the development machine, create a “Sharepoint” instance and voila!

Hope this helps!

Christopher.

Advertisements
This entry was posted in SharePoint 2010 and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s