SQL restore to a different machine

2012-05-22 Thread BrentFortune
I would like to backup a SQL database on one machine then restore it to amother machine. The source server is Windows 2003 32-bit, SQL 2005, SQL TDP V5.5.1.0, Baclient V5.5.1.0 Te destination server is Windows 2008 64-bit, SQL 2008, SQL TDP V5.5.5.0, Baclient V6.2.2.0 Does anyone know if this

Re: SQL restore to a different machine

2012-05-22 Thread Rick Harderwijk
Brent, I assume detach/copy/attach of the database is not an option, so please refer to this IBM document regarding this procedure: http://www-01.ibm.com/support/docview.wss?uid=swg21105967 Regards, Rick On Tue, May 22, 2012 at 12:08 PM, BrentFortune tsm-fo...@backupcentral.comwrote: I would

Re: SQL restore to a different machine

2012-05-22 Thread Zoltan Forray/AC/VCU
From my SQL guy: Sure, we do it all the time. 32bit and 64bit and the version of SQL don't matter as long as you're going up a version (you can't restore to a lower version of SQL). Same goes for TDP actually, as long as you're restoring to a higher version it should be fine. And if they don't