October 20, 2011 at 2:10 am
I accidentally replaced some changes to my package which I shouldn't have and saved it into the server. Is there a way to get back the version of my package before the changes? Its on 2005.
October 20, 2011 at 2:15 am
Is the package stored in the file system or in SQL Server?
Either way, you're probably looking at some sort of restore, unless you have the package stored somewhere else.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 20, 2011 at 2:18 am
SQL server...So do i need to restore msdb database? Can I restore this msdb into test server and retrieve my old package from there? But the test server will also have msdb datbase in it which I don't want to overwrite. How do i go about this?
October 20, 2011 at 2:28 am
SQL_Surfer (10/20/2011)
SQL server...So do i need to restore msdb database? Can I restore this msdb into test server and retrieve my old package from there? But the test server will also have msdb datbase in it which I don't want to overwrite. How do i go about this?
Good question - I don't know the answer for sure. I would probably start by restoring MSDB as some other database and then try to work out how I could get the package out of it. Might be able to INSERT from the restored MSDB to the existing one, once you can find the relevant row - but this needs more research/input before you go ahead.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 20, 2011 at 2:43 am
Two other things you could consider: back up msdb on your test server, then restore over it, then restore the original one back once you've retrieved your package. Or build a new test instance and trash it (or use it for something else) when you've finished.
John
October 20, 2011 at 9:44 am
Phil Parkin (10/20/2011)
SQL_Surfer (10/20/2011)
SQL server...So do i need to restore msdb database? Can I restore this msdb into test server and retrieve my old package from there? But the test server will also have msdb datbase in it which I don't want to overwrite. How do i go about this?Good question - I don't know the answer for sure. I would probably start by restoring MSDB as some other database and then try to work out how I could get the package out of it. Might be able to INSERT from the restored MSDB to the existing one, once you can find the relevant row - but this needs more research/input before you go ahead.
Once you've restored the MSDB, open up visual studio (or BIDS) with a new project. Use the "add existing package" to retrieve the package from the test server into VS, and then publish it again to the correct server, with any potential name/version changes etc....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply