Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

how to restore or keep sql2000 backups useful...

SQL 2012,2016 can restore a SQL 2005 backup, but not 2000
https://msdn.microsoft.com/en-us/library/bb510680(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/bb510680.aspx

if you have old backups from sql 2000, with data that is relevant for archiving.. how can you use it if you move to newer versions?
is keeping sql 2008R2 installed the only option to keep using SQL 2000 backups (thru RESTORE)

could,you advise what is best going forward with old data archived in backup from 2000
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112
25112

ASKER

thank u