| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-05-07 : 13:09:27
|
All,Im pretty confused on this one.I have developed and deployed 10 packages on my Report Manager.Currently these packages are saved on a share drive in our company and are saved in the MSDB folder in SSIS Integration Services in Mngt Studio.Thses packages are also scheduled as jobs on the server itself.Our db is being backed up daily as well.My question:Is there any other way for me to backup the packages in the SSIS Integration Services?Read on msdn, it states that the MSDB db stores SSIS and DTS packages.Does that mean in case my server goes down and I restore my database which includes the MSDB db.This means that when I connect to the SSIS Integration Services after the restore I would be able to see my saved packages on the server as before the restore. Anyone out there who did a db restore and noticed if the saved packages where made available in the SSIS Integration Services after the restore.What are the other possible solutions to ensure my packages are safe?Is doing a FULL db backup, include saving SSIS packages on SSIS Integration Services.Another Question: What about the reports that are made available in the Reporting Services,the subscription of these reports,the Roles that I have created and the scheduling being done for the reports.How can I backup all of these?How to ensure after a db restore all these would be made available in the Reporting Services as well?Help me....Im extremely confused   |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-07 : 13:17:06
|
| For Reporting Services, just backup the ReportServer database (default name, you may have renamed it). It is unnecessary to backup the ReportServerTempdb database (default name, you may have renamed it). For SSIS, I thought that you had to backup the files. I know with DTS that they are stored in msdb, but I thought SSIS was different. I've got limited experience with SSIS, so there's a good possibility I'm wrong.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 13:24:31
|
| For SSIS, it is not necessary they are stored in MSDB.you can keep in file system or shared folder. I would use MSDB for scheduling and File system for my safety reason. |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-07 : 13:33:47
|
[quote]Originally posted by tkizer
For Reporting Services, just backup the ReportServer database (default name, you may have renamed it). It is unnecessary to backup the ReportServerTempdb database (default name, you may have renamed it). For SSIS, I thought that you had to backup the files. I know with DTS that they are stored in msdb, but I thought SSIS was different. I've got limited experience with SSIS, so there's a good possibility I'm wrong.Hi Tara,Thanks for your prompt reply.Are you meaning to say that I just need to ensure my ReportServer and ReportServertempdb are being backed up.And after I restore my db,both these db should be made available.Therefore I would not need to backup my Reporting Services,but by doing the ReportServer and ReportServertemp dbbackup and restore.All previous settings on Reporting Services would appear as if before the restore.Do advise further .Thanks |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-07 : 13:36:16
|
quote:
Originally posted by sodeep
For SSIS, it is not necessary they are stored in MSDB.you can keep in file system or shared folder. I would use MSDB for scheduling and File system for my safety reason.
Hi Sodeep,Thanks for your prompt reply.Could you elaborate futher on the diff, If I were to save it on file system and on msdb ?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-07 : 13:39:14
|
quote:
Originally posted by LOOKUP_BI
quote:
Originally posted by tkizer
For Reporting Services, just backup the ReportServer database (default name, you may have renamed it). It is unnecessary to backup the ReportServerTempdb database (default name, you may have renamed it). For SSIS, I thought that you had to backup the files. I know with DTS that they are stored in msdb, but I thought SSIS was different. I've got limited experience with SSIS, so there's a good possibility I'm wrong.
Hi Tara,Thanks for your prompt reply.Are you meaning to say that I just need to ensure my ReportServer and ReportServertempdb are being backed up.And after I restore my db,both these db should be made available.Therefore I would not need to backup my Reporting Services,but by doing the ReportServer and ReportServertemp dbbackup and restore.All previous settings on Reporting Services would appear as if before the restore.Do advise further .Thanks
I said to only backup the ReportServer database. You can check Reporting Services Books Online for more information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-07 : 13:40:21
|
| Sorry for the typo error.Thanks Tara for your response. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-07 : 13:52:32
|
| Storing in MSDB will keep your package info in it.This will also help when you are hit with disaster:http://technet.microsoft.com/en-us/library/ms156421.aspx |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-07 : 15:13:31
|
| Thanks Sodeep.Will update if I run into any problems. |
|
|
|
|
How To Back Up Integration & Reporting Services?