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