Microsoft SQL Server Backup and Migration Scripts

Highly rated SQL Server 2005 and newer backup scripts: http://ola.hallengren.com/sql-server-backup.html

Microsoft's sample code: stored proc, batch file, and scheduld task: http://support.microsoft.com/kb/2019698

 

Steps to "migrate" a database from a newer SQL Server to an older one

I have used this to copy a database from SQL Express 2012 to SQL Express 2008 (R2 I think)

Script the database Objects and restore them on the server.

Export Steps:

Restore Steps:

Based on: http://sqlserverlearner.com/2011/restore-higher-version-database-backup-on-lower-version-sql-server-restore-problem

 
 

tags: sql, backup, msde, sqlexpress, restore, migrate, 

Related Scribbles:
  • Restore SQL Server 2012 database to SQL 2008
  • Backup Tricks and Links
  • SQL Server


  • ID: 975
    Author:
    leonard
    Date Updated:
    2015-03-01 15:45:01
    Date Created:
    2013-05-09 12:22:18

    Edit

    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Microsoft SQL Server Backup and Migration Scripts
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.