Forum Discussion

pokhreis's avatar
10 years ago

Migrate the database from SQL 2005 to 2008R2

Hi, 

I am pretty new to Symantec backup EXEC 2014. 

I have a SQL Server 2005 instance on my PROD server. I have been given a task to migrate databases from that instance to a different box (SQL Server 2008 R2 on Windows 2008 R2). The current instance has over 8 database which backs up  every night.

is there something called .BAK file that it creates while backing up the database? i am tyring to find one but wasnt able to. i was told that it doenst create the .BAK file using Symantec tool.

Now where do i go to find the file thats been backed up and restore it onto the new SQL Server 2008 R2 instance? 

What is the best approach to migrate all databases in single shot from SQL server 2005 to 2008R2

SQL1 is the SQL server 2005 Service pack 2

SQL 2 is the SQL server 2008R2 service pack 1.

I would apprecaiate if you could advice, me how to do upgrade or migration using Symantec backup EXEC 2014.

 

 

 

  • Are you backing the SQL databases using the BE SQL agent?  If so, then you can just restore the backup to the new SQL instance.  Read the SQL chapter in the Admin Guide.

  • Are you backing the SQL databases using the BE SQL agent?  If so, then you can just restore the backup to the new SQL instance.  Read the SQL chapter in the Admin Guide.

  • There are other factors involved as well when moving DBs from a SQL 2005 to a SQL 2008 R2 instance such as compatibility mode. Have a look @ these articles as well -

    https://technet.microsoft.com/en-us/magazine/gg454217.aspx

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ab2f9e9-bb84-4c06-bbd2-46551c02e196/migrating-database-from-sql-server-2005-to-sql-server-2008r2?forum=sqlgetstarted