Questions On Backup And Report Services
Nov 17, 2006
Hi,
I am thinking of using SQL and VB express for a project. Reading different versions information lead me to the following understanding on bakups and report services. Please comfirm my understanding or correct me if I am wrong. Any suggestion is always welcome.
1. SQL express does not include Agent Job Service so I cannot schedule a backup job or daily report to run automatically at a specific time. Is there a work around on this?
2. If I install the SQL express with the Advance Services edition, I still have to install the express tool kit to get the business intelligence developer studio in order to generate the reports. Do I have to install both on the same machine (the server) or the advance edition on the server and the tool kit on the client machine?
Thanks,
Bernie
View 4 Replies
ADVERTISEMENT
Mar 11, 2008
I'm trying to backup the Encryption Key for the Reporting Services. After I insert the password / location key file and click Ok, I get the following error:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91
---> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's
(Exception from HRESULT: 0x80070A91)
--- End of inner exception stack trace ---
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have tried with diferents passwords but none of them is ok. I don't have any rule on local windows password policy!
Any suggestions?
Thanks!
MD.
View 8 Replies
View Related
Mar 22, 2000
Using Backup wizard it would not let me choose to reorg data and index pages and
also update statistics. I don't understand why these are mutually exclusive. Does
a reorg update statistics for non-unique secondary indexes that are not clustered?
I was also asked if I wanted to backup to a backup device or to a file. In 6.5 I would backup
to a backup device which was a file on my drive. In 7.0 I am missing the distinction of
one being better than the other. Can anyone give a clue to the clueless?
View 3 Replies
View Related
Sep 20, 2006
What is the best way to set up this back up solution. We would like to be able to restore to a point in time.
Here is what I'm planning on doing.
Full backup Sunday nights
Diff backups M-F
log backups Sunday - Friday
Now i'm guessing that we need to set up 3 jobs. The full backup job, the diff backup job and the transaction backup job.
If so i would run the full backup at 6PM on Sundays then have a log job run every 30 minuets from m-f and have a differental backup job run once M-F.
This way i can restore to a point in time correct. I'm just confused with the log backups.
If i need to restore to a point in time say Tuesday night and I take diff backups everyday at 6AM. I would first restore the full sunday backup then the Tuesday diff backup and then the all the log backups that took place after the diff backup correct?
thanks for your time.
View 3 Replies
View Related
Aug 8, 2004
If I have a full backup scheduled at 6pm and a scheduled transaction log backup begins during the 15 minutes the full takes to complete, how would I use the transaction log backup during a recovery sequence?
Does the transaction log backup contain transactions that are captured in the full recovery since they both occured concurrently? Using RESTORE HEADERONLY I see they both are stamped as finishing at the same time.
Would I restore the full and then restore this tran log backup or go to the next tran log backup?
Thanks,
Ken
View 1 Replies
View Related
Mar 20, 2007
In SQL 2005 SMO
documentation, there is a DeviceType enum:
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.devicetype.aspx
It
seems there is no doucmentation about 'LogicalDevice', what's the
difference between that and 'VirtualDevice' ? (for the latter, I guess
we need to implement a VDI driver)
Another question is that,
suppose we want to backup a database to a hard drive file, I could use
either T-SQL or SMO, what's the advantage of using SMO?
Thanks!
View 3 Replies
View Related
Aug 24, 2007
I made a dsicovery today that must change the way I do backups. I realized that each backup ADDs the whole database to the previous backup without deleting the previous instances (for previous backup days). If it is true, and I want Jens or someone else to confirm it, then what shall I do?
I do not need this old archive. I want to just store the latest version of my database. What I've had so far is a waste.
The log files also grow to enormous size for no reason.
Shall I delete all backup files each time and recreate them before doing backups?
Also, I have trouble opening up log files. I think I did it once or twice in the past but now do not remember how I did it. The system is asking me for a proper editor and anything I tried did not work.
How shall I open a log file
Thanks.
View 5 Replies
View Related
Nov 15, 2004
Hi everybody,
I am trying to figure out SQL Backup and restore and I was wondering if you guys could enlighten me.
I figured out how to restore a DB on my local sql box but let's say my server catches on fire and my backup is on tape, how do I restore my DBs on a different box ?
I have a second machine I built for test but apparently it won't restore from the tape.
What is the best way to back up your data in case of major hardware problem ? And how to restore it to a completly different server. I am running tapeware w/ sql agent.
Thank you, any help will be greatly appreciated. -Seb
View 2 Replies
View Related
Feb 12, 2008
Hello,
1) We run full backup on SQL server 2005 on weekly basis (Sundays), diff - every night, and backup of tran logs every hour. Let me descrive the following scenario: if our server would crash on Wednesday at 5 pm, how can I restore it properly? Do I need to restore it from full Sunday backup + latest diff backup from Tuesday night + latest tran logs from 4 pm? We have full recovery mode on the databases.
2) If we change recovery mode from full to simple, is it possible we have data loss in case if the server crashes let's say at 1 pm, and we have full backup only from previous midnight only?
Thank you,
Julie
View 7 Replies
View Related
Jul 23, 2005
Hi All,I have several questions about checking backup file :a. When SQL Server receive a command :BACKUP DATABASE test to DISK = '\pc1etdbBTEST',does it verify BTEST file before ending the job ?b. Is there any special command for checking / verifyinga backup file ?c. If I send a restore command using a file infectedby a virus, what action will SQL Server take ?Thanks in advanceJohn S*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Mar 31, 2007
Hi all. I have many concerns on reporting services. Hope you help me alot explaining as I fully undestand it.
1. I am new in reporting services. Anybody can tell me the BIG difference of SQL SP1 and SP2?
2. Can anyone give the SHARED FUNCTION/ aggregate method not being supported by the aggregate functions. (These are the methods written in REPORT CODE)...
3.I have REPORTS(Business Intelligent Project) on my local machine hosted to the report services of the MACHINE SERVER. Then, reports are shown in REPORT VIEWER in my C# WINDOWS application project. My question is : How can other workstations run the same reports(Reports that I made)? We are using Team Foundation Server(TFS) to share the REPORTS and C# application project. I not yet tried to share the report, however I am expecting the report will work in other workstation. Is it?
4. Reporting services will only run in IIS, right? and you need first to RUN the SQL MANAGER, right? I have 10 workstations and 1 SERVER MACHINE. I made the SERVER MACHINE as the report server. Am I doing right? or Am I thinking the right idea/approach? Give me guidance on this...
5. What are the advantages of the reports being hosted to the reporting services? or shall i say, what is the difference of the crystal report to the reports hosted to the reporting services.
.:. Edit...(Added)
6. Can someone tell how to set the datasourcecredential in my c# windows application? I see the methods in MSDN but I really don't know how to use the methods.
7. How to set the reports directly to PRINT LAYOUT MODE if I preview it?
Thanks.
-Ron-
View 1 Replies
View Related
Nov 8, 2004
I've installed SQL Server Reporting Services and designed few useful reports on local workstation, now I want to deploy those on the production reporting server.
I have the following questions:
1) We have some demo databases with the similar structure so the the same report would fit all the demos.
Is there any way to change the connecting string for the report programmatically without recreating report each time ? May be there is a way to pass database name to the report (encrypted) ? Is there any way to
2) I'd like to be able to protect those reports from unauthorised users ? Is there any way of doing that ? Is there any way to set up security on the base of folder anf for the whole group of reports ?
Thanks
Mikhail
View 4 Replies
View Related
Mar 14, 2008
A couple questions about SQL Server Reporting Services:
1. Can it be used for other data sources besides SQL Server (Oracle db, XML files, via APIs, etc.)?
2. Can it do ad hoc reporting? I like the "universes" that the SAP Business Objects product allows. Does Reporting Services have something like this, to provide a simplified view that non-technical business users can use to create their own reports? Or is Reporting Services just the equivalent to Crystal Reports?
(I wanted to post this in the general MSDN forum for SQL Server, but I can never log in there for some reason.)
View 3 Replies
View Related
Aug 28, 2007
Where do I post Reporting Services 2005 Questions
Thank you,
View 1 Replies
View Related
Mar 11, 2008
Hello, we have a customer-facing ASP.NET web reporting application that allows the user to a). select a report b). make report settings (filter, sort, include/exclude columns), and c). run the report. An Oracle stored proc is used to return the data into a DataSet. Today the output is displayed in a bound, paginated DataGrid.
We€™d like to €˜plug-in€™ Reporting Services for improved formatting, grouping, matrix reporting, drilldown, graphics, etc.. I have read through the online docs, examples, and tutorials but have not found the exact (high-level) information I€™m looking for.
We need to keep our report settings page, Oracle SP architecture, etc... Is there a way to simply hand off a dynamically created DataSet to a report for display €“ like binding to the DataGrid? The data (query) would be specific to a report but columns can be selected/unselected for display.
In terms of deployment, is it necessary to install SQL Server in each environment (DEV-Integration, QA, PROD) to support Reporting Services? Since we are essentially an Oracle shop, this could be a tough sell. Is it possible to develop the report on a dev workstation (perhaps with SQL Server), and then publish to a web server where SQL Server is not installed?
These are obviously high-level questions - any help will be appreciated (examples, how-to's, etc..) €“ thanks in advance.
-Bill
View 1 Replies
View Related
Sep 9, 2015
I just created a report builder. I have a main report and i wanted to create a sub report. why i cant or i cant view the path or the folder of my .rdl file to be use as my sub report.
View 5 Replies
View Related
Sep 12, 2007
Hi All,
We are post-deployment with a serious reporting issue that's causing us to rethink our reporting solution. We're considering moving from what we have to SQL Server Reporting Services (client side).
I have spent the past couple of days getting up to speed on this feature and seeing if we can easily migrate it into our existing application. However, I've hit a couple of stumbling blocks and was hoping perhaps someone here could either tell me the solution or point me in the right direction.
I'm not having any problems creating basic reports (e.g. flat data).
However, I am having problems creating reports where there are related tables in a dataset.
The way it works with our existing solution is that I get a dataset (which contains several data tables) and point it to the report's datasource. That report expects those tables and I have defined table-relationships in the report which process and display the information correctly.
I'm not having as much luck with RDLC.
I can go into futher detail about how I'm creating the report, but let me just ask these general questions first:
1. Can I set a dataset containing multiple datatables equal to a property on an RDLC report and that RDLC report know how to treat and display the data?
2. Is there a better/smarter than this to get a field selection from my datasource (remember, this information is coming from a stored procedure so connecting directly to the database is not an option):
a. In code, populate dataset
b. In code, write dataset schema to xml (e.g. an xsd file)
c. In Visual Studio, add the XSD file to project
d. Use fields from XSD file to drag and drop fields on report
A fancy example would be nice too. I've googled like crazy the past couple of days and downloaded as many samples as I can find (including the ones on ftponline.com, gotreportviewer.com, "Tudor's WebLog", and several others). However, I have yet to find one that uses grouping and related datatables.
Thank you so much (if, for nothing else, reading this post )
View 4 Replies
View Related
Aug 13, 2007
I have a program where I have to do a weekly data upload of approx 1,500 records. I've written the sql, but need to know how I can add static header text to the SQL statement.the text I need in the header is Reportname(Static string) + #rows (Rowcount of the sql, int) + department (String static) I'm planning on writing it and saving it as a package, then schedule it to run every Friday at 5:00. But I have been reading a little on Reporting Services and wonder if people think it' might be the way to go? Is it a whole new area of security issues? Or is it worth installing and learning? I will have more and more reports I need to write that will increase in complexity, and want to know if I want to keep writing querys by hand, or use reporting services. Thanks in advance! Dan
View 5 Replies
View Related
Oct 9, 2015
I have done the following and a domain user would not access report created a login to the SQL server to the user (this SQL Server is where data source DB is)went to site setting in Report Manager and made this use a system userright clicked on report folder and made this user in the browser roleeven checked that in the report in question, the user is already in the browser role Still the user would not access the report! "User .......... does not have required permission" is the error message I am getting.Â
View 6 Replies
View Related
Jul 5, 2012
I have written a report visual studio. Â The report has 10 multi-value parameters that pull data from their individual data sets within the reports. Â When running the report from within Visual Studio it renders fine. Â There are no errors reported, only a warning related to a pathname I have use to retrieve image data and display on the report.Deployment of the report is error free.When I view the report I briefly get the "Loading" splash window, but then nothing. Â None of the headers or static text is displayed. Â The results window is blank.
The report defaults all the parameter values. Â In trying to debug the issue I have found by reducing the number of parameter values the report will render. Â Once I have all the values added, the report does nothing.Below is the query being used for the report. Â The where clause in the query shows the parameters being used and the syntax.We are running on Windows Server 2008 R2 and SQL Server 2008 R2.
Ralph
SELECT RTRIM(a.ITEMNMBR) AS Style, RTRIM(a.ITEMDESC) AS Description, a.ITMSHNAM AS UPC, c.LOCNCODE AS Store, d.LISTPRCE AS ListPrice, a.CURRCOST AS Cost,
a.USCATVLS_1 AS [Main Category], a.USCATVLS_2 AS Market, a.USCATVLS_3 AS [Alternate Retail], a.USCATVLS_4 AS Country, b.ITEMXTRAS_1_Type AS Type,
b.ITEMXTRAS_2_Finish AS Finish, b.ITEMXTRAS_3_SubCategory AS SubCategory, b.ITEMXTRAS_4_Department AS Department,
[code]...
View 7 Replies
View Related
Nov 23, 2015
We are about to implement SSRS reports (SQL Server 2012), and have found one issue we don't like. The report looks great when we open it in pdf format. However, when we open it in Excel format, we want it to be the raw data, not look like the pdf report. I tried the simpl headers, and that removed the page header/footer. However, the report format was still in play.In other words, we would like the report when opened in Excel, to look just like it does when we open it as a CSV.I have tried to modify the config file a couple of times. Here is my latest attempt:
Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
    <OverrideNames>
     <Name Language="en-US">CSV (comma delimited)</Name>
    </OverrideNames>
   </Extension>
   <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
    <OverrideNames>
     <Name Language="en-US">Excel (csv)</Name>
    </OverrideNames>
   </Extension>
Essentially I have set Visible = "false" for the Excel type, and tried to duplicate the CSV, changing the name to make it look to the user like it is "Excel". This fails. I checked the event viewer, and I see two entries.. The RSReportServer.config file has been modified. (Information)The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.I literally took the file, opened it in Notepad, pasted in my changes, from another notepad window, and tried to run the report. I did not see EITHER of the two names I expected, using the OverrideNames tag. As I said earlier, I was able to affect the outcome, by setting SimpleHeaders to true (or however it is identified). That did work in that the page header and footer was removed.
View 6 Replies
View Related
Sep 21, 2015
I have a ssrs report having 2 tables in with 4 columns in each. When I go to export option in preview I can see all data coming in one excel sheet, But I am trying to get 2 tables in 2 different pages in Excel when I export.First page of excel comes with first table data with 4 columns and second page of excel comes with second table data with 4 columns .
View 2 Replies
View Related
Apr 16, 2015
I am working on reports in SSRS 2008 (not R2)... There are some reports with parameters that are hidden when the report is accessed through normal URL using ReportViewer.asx..The thing is that these hidden parameters need to be visible when the report is accessed using SSRS Report Manager.
View 3 Replies
View Related
Jun 29, 2015
I'm wondering how to print a SSRS report without bringing up a report viewer. Is there way to print(PDF format) the SSRS report in the web application(Â .net ) Â directly from the "print" button without bringing up a report viewer?
View 2 Replies
View Related
Oct 28, 2015
I have a report builder drill down report. I have row groups with totals.   It looks like the attached.  The problem is when the report is not expanded the Grand Totals column is not accurate... it is displaying the totals of one of the rows when expanded.The expression in the Total Show text box is
= Switch ( Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
MID(Fields!protocol_id.Value,1,7)="THERAPY", Â Â Â Â Â Â Â Â Â Â
                     Sum(IIF(Fields!status.Value = "CO", CDbl(Fields!TX_CO.Value),      Nothing)),
 MID(Fields!protocol_id.Value,1,7) = "GENERAL" and                          MID(Fields!program_id.Value,1,6)
= "INTAKE", Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Sum(IIF(Fields!status.Value = "CO",
[code]...
Is there any way to not display the expression in the Total columns unless the report is expanded?
View 2 Replies
View Related
Aug 28, 2015
I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports generate dynamically. Since the report project doesn't exist anymore, I can't set the data source through code. How can I set the data source for the whole folder?
View 7 Replies
View Related
Oct 15, 2015
I was able to log in to SSRS report manager. But i was unable to run a report i designed on report builder.
It prompts for login when i wanted to run the report and i used the same windows authentication to sign in
It will show me the parameters but when i click on view report it gives this error
 "Data source 'DataSource1': An error has occurred.
Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'DataSource1'. ---> System.Data.SqlClient.SqlException: Login failed for user 'Acc-11Admin'."
View 4 Replies
View Related
Jul 20, 2015
I want to repeat line on each page of report on PDF while using 2 columns on report. The problem is that if i use table border it will also repeat after second table. i want a line between two tables.
View 14 Replies
View Related
Apr 28, 2015
We are generating excel report using report viewer at run time but if excel report having more then 65000 record generating error Microsoft. Reporting Services.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceed.
View 2 Replies
View Related
Sep 16, 2015
I am trying to develop a report from cube,and it has one drill through report.when i click on sales amount field on main report,then it open the drill through report with details.Here i passed the **(category,subcat,product)parameters(Cascaded)** to drill through report in action part of main report.In my main report i have two columns .
columns are **Level**  and        **Salesamount**. Â
Values are like Â
**[-]category** Â Â Â Â Â Â Â **100**
  **[-]subcat**       **50**
     **product**      **30**
when i click on 100, parameters are passed & it open the detail report correctly, but when i click on 50,the values for subcat parameter is not getting values in detail report and same as the product also.
Here i used the expressions in parameter values
**pCategory**----iif(inscope(category),!fields.category.value,split(join(Parameters!category.value,","),","))
**psubcat**----iif(inscope(subcat),!fields.subcat.value,split(join(Parameters!subcat.value,","),","))
**pproduct**----iif(inscope(product),!fields.product.value,split(join(Parameters!product.value,","),","))
View 3 Replies
View Related
Oct 6, 2015
How do I get data on my linked report based on my grouped subtotal and grand total from the main report. The subtotal and grand total are calculated columns.
I have a 3 columns in my matrix in the SSRS summary report. Actn_COAST, ActnCITY and NumbOfAccts. Â
The following is code for my summary report. The results are shown below.
SELECT Distinct ActnCITY, Count(ACCT) as NumbOfAccts,
CASE WHEN ActnCITY in ('NY', 'OH', IN, 'NJ', 'SC', 'NC') THEN 'EAST COAST'
WHEN ActnCITY IN ('CA'. 'NV', 'UT', 'WA', 'OR') THEN 'WEST COAST'
ELSE 'OTHER'
END AS Actn_COAST
FROM tbl1
where ACTNDATE between @STARTDT and @EndDT
Code for my detail report contains the following SQL
SELECT * FROM tbl1 where ACTNDATE between @STARTDT and @EndDT AND @ActnCITY = ActnCITY
I have linked my report based on the NumbOfAccts column. I am able to get data if I click any of the NumbOfAccts values related to the state I want. However when I am not sure how to make the subtotal and grand total work. I want when I click on the subtotal of either coast, I should be able to see records of that coast e.g., if I select 37 I should be able to see all the records in East Coast. If I click on the Grand Total, I only want data related to those 2 coasts.
View 2 Replies
View Related
Feb 8, 2015
Is there a way to subscribe SSRS report using dynamic parameters for email and trigger the report from autosys job so that report should generate the exact time the job is triggered.Let me describe, my SSRS report should be triggered on success of one autosys job. i need to send email parameter and time of report schedule from this autosys job.
View 3 Replies
View Related
