Restore failed for server ‘SEEKEY – NOTESQLEXPRESS’

Asked By 0 points N/A Posted on -
qa-featured

Hi everyone,

After problems with electricity my server went down. I have done back up of all files on other server. When I wanted to restore backup files .bak with SQL express I got error message. Now I don’t know what to do. How can I fix this? OS Windows 7

Thank you.

Cody

Microsoft SQL Server Management Studio-System.Data.SqlClent.SqlError

Microsoft.SQL Server Management Studio

Restore failed for server ‘SEEKEY – NOTESQLEXPRESS’. (Microsoft.SqlServer.SmoExtended)

Additional information:

System.Data.SqlClent.SqlError: The database was backed up on a server running version

10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either

restore the database on a server that support s the backup, or use a backup that is compatible with

this server. (Microsoft.SqlServer.Smo)

SHARE
Answered By 0 points N/A #123350

Restore failed for server ‘SEEKEY – NOTESQLEXPRESS’

qa-featured

It is a common problem for all of us who are using SQL Server; always problem with the version. I am using SQL server 2005 and my another colleague in different location using 2008 and same problem happening to me as well then I told him to do Generate script database and this problem has been resolved.

Please follow these below step to resolved the problem:

object explorer-DB_Accounting_System Script Wizard-Select Database Choose Script Options Output Option Generate Script Progress

Thanks,

Ashik

Related Questions