>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 want to use TSM, they can always just do a native SQL backup, transfer the backup file, then restore.
Zoltan Forray TSM Software & Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services [email protected] - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html From: BrentFortune <[email protected]> To: [email protected] Date: 05/22/2012 12:23 PM Subject: [ADSM-L] SQL restore to a different machine Sent by: "ADSM: Dist Stor Manager" <[email protected]> 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 is possible, if not, how can i plan for getting the SQL 2005 databases to the SQL 2008 server. Regards Brent +---------------------------------------------------------------------- |This was sent by [email protected] via Backup Central. |Forward SPAM to [email protected]. +----------------------------------------------------------------------
