Backup & Restore between different versions

• 
  In terms of backing up and restoring between different versions of SQL Server, whatever you can do using SQL Server backups, you can do the same with SQL Backup backups.

  petey October 25, 2007 03:47

  - 0 +
• 
  Thank you Peter for the reply. The problem i have with SQL Server way of backing and restoring is that, SQL Server 2005 doesnt allow me to put the Db in standby mode(which would help me apply more differentials) while restoring a db from a different version and the NoRecovery option accepts more differentials but makes the database unusable. I want it to atleast be in a Read-Only mode(Standby) so that i can apply more differentials and at the same time use the DB for my reporting purposes....
  
  Regards
  Sukesh

  sk75 October 25, 2007 04:40

  - 0 +
• 
  That's a SQL Server requirement. SQL Backup cannot work around that requirement.

  petey October 25, 2007 05:36

  - 0 +

Add comment

Please sign in to leave a comment.