<div>
Well, what error?<br />
<br />
SQL Server 2014 can restores user databases from SQL Server 2005+. <br />
<br />
Do you have enough space on the target drive? If your 2008 instance was Enterprise or higher, than the backup maybe also compressed.
</div>


Math Tec

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to backup SQL database from old server (SQL 2008) which is installed on windows server 2008R2 to new server (SQL 2014) which is installed on windows server 2012. The database is large (around 200G). I did the backup using SQL management Studio and I got the backup file. However, I tried to restore in the new server using restore database from management studio (SQL 2014) but I got an error.<br />
<br />
Any suggestion how to backup and restore database from SQL 2008 to SQL 2014<br />
<br />
Thx
</div>
</div>


Hi,

I am trying to backup SQL database from old server (SQL 2008) which is installed on windows server 2008R2 to new server (SQL 2014) which is installed on windows server 2012. The database is large (around 200G). I did the backup using SQL management Studio and I got the backup file. However, I tried to restore in the new server using restore database from management studio (SQL 2014) but I got an error.

Any suggestion how to backup and restore database from SQL 2008 to SQL 2014

Thx

Backup SQL database from SQL 2008 and restor to SQL 2014

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.