SQLTeam.com | Weblogs | Forums

SQL Backup


Hi All,

I am taking backup of SQL Server 2012 from one machine to another machine. Just wanted to know that once i will restore will my Packages from old server also will be built in new

Or i have to create packages again in new Sql Server


How will you do the backup? Note that package are stored in SSISDB in 2012


Not necessarily. They can be stored in msdb or SSISDB. We have a mixture of both on our SSIS 2012 server.


yeah, true that


and also on the files system of course.