SQL Backup

Transact-SQL
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.