SQLTeam.com | Weblogs | Forums

SQL Backup


#1

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


#2

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


#3

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


#4

yeah, true that


#5

and also on the files system of course.