Math Tec
asked on
Backup SQL database from SQL 2008 and restor to SQL 2014
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Server 2014 can restores user databases from SQL Server 2005+.
Do you have enough space on the target drive? If your 2008 instance was Enterprise or higher, than the backup maybe also compressed.