Examples of the Restore command

Comments

• petey Redgate › Posts: 2,358 New member

  August 29, 2008 12:44PM

  The syntax is similar to that for regular T-SQL restores e.g.
  

  EXEC master..sqlbackup '-sql "RESTORE DATABASE AdventureWorks FROM DISK = [g:\backups\AdventureWorks.sqb] WITH MOVE [AdventureWorks_Data] TO [h:\sqldata\AdventureWorks_Data.mdf], MOVE [AdventureWorks_Log] TO [l:\sqllogs\AdventureWorks_Log.ldf]" '
  

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• rand201 Posts: 9

  August 29, 2008 1:03PM

  I need to use a REPLACE it says.

  Thanks
  
  Art

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 29, 2008 1:10PM

  That's the standard SQL Server message you're seeing, if you are restoring over an existing database whose transaction log contains data that has not been backed up.
  
  If you don't need the data in the transaction log, then run the restore command with the REPLACE option e.g.
  

  EXEC master..sqlbackup '-sql "RESTORE DATABASE AdventureWorks FROM DISK = [g:\backups\AdventureWorks.sqb] WITH MOVE [AdventureWorks_Data] TO [h:\sqldata\AdventureWorks_Data.mdf], MOVE [AdventureWorks_Log] TO [l:\sqllogs\AdventureWorks_Log.ldf], REPLACE" '
  

  
  Otherwise, back up the transaction log before running the restore.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• rand201 Posts: 9

  August 29, 2008 1:43PM

  Can you tell me RedGate SQL Backup is cluster aware?

  Thanks
  
  Art

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  August 30, 2008 1:45AM

  When you install SQL Backup on a cluster, does it recognise that the selected instance is a cluster resource, and provide an option to install on all cluster nodes, and install SQL Backup as a cluster resource? Yes.
  
  When you upgrade SQL Backup, does it also upgrade all cluster nodes, if the account running the upgrade has adequate rights? Yes.
  
  When you uninstall SQL Backup, does it also uninstall from all cluster nodes, if the account running the upgrade has adequate rights? Yes.
  
  When SQL Backup is installed on a cluster, does it know how to use the SQL Server cluster name instead of the machine name? Yes.
  
  All the above applies only to clusters running Microsoft Clustering Services. If your clustering uses technology from another vendor, we will need to address it separately.
  
  Does the above address your 'cluster aware' question?

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• rand201 Posts: 9

  September 2, 2008 8:59AM

  That does answer all my questions. Thanks.

  Thanks
  
  Art

  0 · Share on Twitter